Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[20 pts] Question 19: Design an Entity Relationship diagram that represents the following information. Identify the attributes. A customer places an order that contains many
[20 pts] Question 19: Design an Entity Relationship diagram that represents the following information. Identify the attributes. A customer places an order that contains many products which are produced by many manufacturing companies. 1. Customers are identified by their unique number. They have an email ID and physical address. Several customers may live at the same (physical) address, but we assume that no two customers have the same email address. 2. Manufacturing companies have a name, which we may assume is unique, an address, and a phone number. 3. Products have product ID, product name, a model number, a type (e.g., gaming device)and quantity on hand. Each product is made by one manufacturer and different manufacturers may have different products with the same model number. However, you may assume that no manufacturer would have two products with the same model 4. An order has a unique order number and a date. An order is placed by one customer. 5. For each order, there are one or more products ordered, and there is a quantity for each product on the order. [20 pts) Question 20: Calculate the estimated product completion time and provide a realistic conclusion for the case provided below. Please use today's date and show ALL the steps to derive your answer. Compute the following: 1. BAC 2. BCWP 3. BCWS 4. Earned Value (EV) 5. Schedule Performance Index (SPI) 6. Schedule Variance (SV) 7. ACWP 8. Cost Variance (CV) 9. CPI 10. Is the project on schedule? Explain your answer to provide a conclusion. Work Task Estimated Effort (Prog. Days) Actual Effort so far (Prog. Days) Estimated Completion Date Actual Completion Date 1 5 5 9/28/2021 9/27/2021 2 10 40 10/10/2021 3 20 14 11/2/2021 11/22/2021 4 10 6 12/8/2021 Reference: Progress Indicators EV - Budgeted Cost of Work Performed / Budget at Completion SPI = Budgeted Cost of Work Performed / Budget Cost of Work Scheduled SV - Budgeted Cost of Work Performed - Budget Cost of Work Scheduled . CPI - Budgeted Cost of Work Performed / Actual Cost of Work Performed . CV - Budgeted Cost of Work Performed - Actual Cost of Work Performed
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started