management accounting midterm
AK/ADMS 2511 - Management Information Systems – Practice Midterm #1 Questions
Covering Sessions 1 to 4
Question 1 (10 marks – 30 minutes)
Greenville Hospital is a modern facility that prides itself on having accurate patient information and well integrated accounting systems. The hospital is always looking for new ways to use computer systems so that its medical staff can spend more time with patients. The hospital has an up-to-date hardware and software infrastructure using wire-based systems.
Required:
A) For each of the following information system types provide a definition and an example system, explaining how the example system could be used by Greenville Hospital. (4 marks)
TPS – Transaction Processing System
DSS – Decision Support System
B) Following is an extract of information from Greenville Hospital’s payroll database.
Employee number
Employee name
Wage rate per hour
Regular hours worked
Overtime hours worked
54624
Amalie Smith
10.00
40
5
54968
Harrison Chan
15.00
40
0
69002
Cindy Flaherty
14.00
40
6
To document the data model for payroll, describe the following three components of the data model and provide an example from the table that illustrates the characteristics of the component. (6 marks)
Describe component of data model
Example from table the characteristics of the component
Primary key
Attribute
Entity
Question 2 (15 marks – 45 minutes)
Chevron Corporation is a large multi-national energy corporation with over $200 billion in sales. In Canada, Chevron operates as Texaco, which includes head office, manufacturing and distribution, and retail gasoline stations. In information technology alone, the company employs about 3,500 people, has about 10,000 servers and processes a million email messages daily.
Required:
A) Our textbook describes four general categories of
Covering Sessions 1 to 4
Question 1 (10 marks – 30 minutes)
Greenville Hospital is a modern facility that prides itself on having accurate patient information and well integrated accounting systems. The hospital is always looking for new ways to use computer systems so that its medical staff can spend more time with patients. The hospital has an up-to-date hardware and software infrastructure using wire-based systems.
Required:
A) For each of the following information system types provide a definition and an example system, explaining how the example system could be used by Greenville Hospital. (4 marks)
TPS – Transaction Processing System
DSS – Decision Support System
B) Following is an extract of information from Greenville Hospital’s payroll database.
Employee number
Employee name
Wage rate per hour
Regular hours worked
Overtime hours worked
54624
Amalie Smith
10.00
40
5
54968
Harrison Chan
15.00
40
0
69002
Cindy Flaherty
14.00
40
6
To document the data model for payroll, describe the following three components of the data model and provide an example from the table that illustrates the characteristics of the component. (6 marks)
Describe component of data model
Example from table the characteristics of the component
Primary key
Attribute
Entity
Question 2 (15 marks – 45 minutes)
Chevron Corporation is a large multi-national energy corporation with over $200 billion in sales. In Canada, Chevron operates as Texaco, which includes head office, manufacturing and distribution, and retail gasoline stations. In information technology alone, the company employs about 3,500 people, has about 10,000 servers and processes a million email messages daily.
Required:
A) Our textbook describes four general categories of