Solved by Expert Tutors
Solved by Expert Tutors
Question

Subject: Management Information Systems

Scenario: Your family owns a company that makes personal protective equipment for industry. There are 100 employees. Last year, your net profit was 1.5 million dollars. Your grandfather has been the CEO for the last 30 years and has been very resistant to spending money on information technology. You do not have an internal network, and people are connected to the Internet, individually, using an external provider. Your grandfather has stepped down and your mother is the new CEO. She has asked you to make an MIS strategy and plan for the organization. You are currently taking an MIS course and have covered the first four chapters of your text. You will consider the current (mid-June, 2020) business environment and what can be predicted, for your business, going forward. You will also contemplate how you can integrate MIS into an organization with the following departments: Human Resources, Accounting, Purchasing, Shipping and Receiving, Supplies and Warehousing, Maintenance and Manufacturing. Currently, you use a safety supplies distributor to sell your products. See Appendix 1 for an organizational chart. Because there has been intense competition from Asia, your company has concentrated on a customer-oriented strategy of competition. You will need to consider available funds in arriving at any recommendations (any recommendations need to meet your needs without being too extravagant - you won't be providing pricing at this time).


Question: You are recommending a database and are going to demonstrate how it could help organize HR, as an example. You will provide an entity-relationship diagram using the modelling method. You will have entities for employees, payroll and benefits. See Appendix 2 for the salary structure. Note that all employees receive extended health, pension, education and vacation benefits. Employees at level 3 and above receive car allowances and profit-sharing benefits. Please state any other business rules that you apply to your drawing. Each entity will have five attributes, including the primary key. Add intersection tables, with at least one attribute plus key attribute(s). (25 marks)


Appendix 2:

Pay Structure


Postion Level Pay

CEO 1 250,000 per annum

Manager 2 150,000 per annum

Supervisor/Foreperson/Buyer/Adminstrator 3 100,000 per annum

Secretary/Clerk 4 75,000 per annum

Staff 5 70,000 per annum

Step-by-step answer

a molestie consequat, ultrices ac macinia pulvi

HR_DataModel.png

ipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel

HR_DataModel.png
nec facili dictum vi pulvinar tortor nec inia pulvi consectetur adipiscin congue vel laore icitu o. Donec aliquet. dictum vita dictum vita usce dui lec itur laoree ec aliquet. Lorem

Subscribe to view the full answer

Subject: Business, Management

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Management tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes