4. Please draw an ER Diagram for a University described below: (50 pts) a. The university has multiple Departments. The attributes of Departments include Department ID and Department Name. b. The university has Employees who are divided into 3 SUB-categories: Faculty, Staff, and Administrator. An Employee must be assigned to one and only one of these categories. All Employee have Employee IDs and Names attributes. Faculty members have an Academic Title attribute. Staff has a Part Time_or_FullTime attribute. And Administrators have a Position attribute. C. All Faculty members work in one Department and only one Department. d. A Department is always managed by a department chair who is a Eaculty member works in that Department. e. The university offers multiple Courses. Each Course has its own ID and Name attributes. f. Each Course must be taught by one or more Faculty members. Each Faculty member may or may not be teaching courses. And when they do, they may teach multiple courses. 5. Please convert the ERM you created for question 4 into a Relational Schema with all the tables, their fields, dependencies between the fields, primary keys and foreign keys marked out. (30 pts) Use the accompanying Profit Analysis spreadsheet model to answer the following questions. Click here for the Excel Data File a. Use the data table tool to show the impact of quantity ranging from 1,500 to 6,600 with 500 unit increments on the total revenues, total costs, and total profits. What are the revenues, costs, and profits for 5,100 units? Total revenues Total costs Total profits b. Use the data table tool to show the impact of labor costs ranging from $5.00 to $8.00 with $0.50 increments and price per item ranging from $10.99 to $15.99 with $1.00 increments on the total profits. What is the total profit if the labor costs are $6.50, and the price is $14.99? Note: Round your answers to 2 decimal places. Total profit c. What is the breakeven quantity using the assumptions in the spreadsheet model? Note: Round your answer to 2 decimal places. The breakeven point for quantity Paste LO 田、 Clipboard Б Assumptions: BIU AA X Font A Б fx Assumptions: Fixed cost: $ 6,600.00 Material costs per item: 2.25 Labor costs per item: $6.50 Shipping costs per 100 item: $ 200.00 Price per item: $ 12.99 Quantity: 3600 Total profits: Total costs: Outputs: Total revenues: $ 1,464.00 $45,300.00 $46,764.00 10 Alignment Number D E EAS US 2

4. Please draw an ER Diagram for a University described below: (50 pts) a. The university has multiple Departments. The attributes of Departments include Department ID and Department Name. b. The university has Employees who are divided into 3 SUB-categories: Faculty, Staff, and Administrator. An Employee must be assigned to one and only one of these categories. All Employee have Employee IDs and Names attributes. Faculty members have an Academic Title attribute. Staff has a Part Time_or_FullTime attribute. And Administrators have a Position attribute. C. All Faculty members work in one Department and only one Department. d. A Department is always managed by a department chair who is a Eaculty member works in that Department. e. The university offers multiple Courses. Each Course has its own ID and Name attributes. f. Each Course must be taught by one or more Faculty members. Each Faculty member may or may not be teaching courses. And when they do, they may teach multiple courses. 5. Please convert the ERM you created for question 4 into a Relational Schema with all the tables, their fields, dependencies between the fields, primary keys and foreign keys marked out. (30 pts) Use the accompanying Profit Analysis spreadsheet model to answer the following questions. Click here for the Excel Data File a. Use the data table tool to show the impact of quantity ranging from 1,500 to 6,600 with 500 unit increments on the total revenues, total costs, and total profits. What are the revenues, costs, and profits for 5,100 units? Total revenues Total costs Total profits b. Use the data table tool to show the impact of labor costs ranging from $5.00 to $8.00 with $0.50 increments and price per item ranging from $10.99 to $15.99 with $1.00 increments on the total profits. What is the total profit if the labor costs are $6.50, and the price is $14.99? Note: Round your answers to 2 decimal places. Total profit c. What is the breakeven quantity using the assumptions in the spreadsheet model? Note: Round your answer to 2 decimal places. The breakeven point for quantity Paste LO 田、 Clipboard Б Assumptions: BIU AA X Font A Б fx Assumptions: Fixed cost: $ 6,600.00 Material costs per item: 2.25 Labor costs per item: $6.50 Shipping costs per 100 item: $ 200.00 Price per item: $ 12.99 Quantity: 3600 Total profits: Total costs: Outputs: Total revenues: $ 1,464.00 $45,300.00 $46,764.00 10 Alignment Number D E EAS US 2

Foundations of Business (MindTap Course List)

6th Edition

ISBN:9781337386920

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Chapter9: Attracting And Retaining The Best Employees

Section: Chapter Questions

Problem 13DQ

See similar textbooks