Question: 1-8 data modeling diagram please & thank you 8 pts PART II: Data Modeling (12 points) 4pts Diagram represents the Diagram is complete stated requirements;

1-8 data modeling diagram please & thank you 1-8 data modeling diagram please & thank you 8
8 pts PART II: Data Modeling (12 points) 4pts Diagram represents the Diagram is complete stated requirements; is with explanatory text accurate and complete, with correct notations, correct entities and relationships 4pts Opts Diagram captures most Diagram does not but no all requirements; match the stated missing or incorrect requirements entities and relationships Develop an Entity-Relationship model for the purchasing requirements described below. 1. The purchasing department of a company issues purchase orders (PO) to its suppliers. 2. Each PO is for one supplier. 3. Each PO has one or more line-items (PO LINE-ITEM). 4. Each line item belongs to one PO, 5. Each line item is for one product from a supplier 6. A supplier may supply one or more products. 7. A product from a supplier could be in multiple purchase orders. 8. The status of a PO is tracked at the line item level. Example of statuses are "line item shipped", "line item received", "line item rejected", "line item paid", etc. 8 pts PART II: Data Modeling (12 points) 4pts Diagram represents the Diagram is complete stated requirements; is with explanatory text accurate and complete, with correct notations, correct entities and relationships 4pts Opts Diagram captures most Diagram does not but no all requirements; match the stated missing or incorrect requirements entities and relationships Develop an Entity-Relationship model for the purchasing requirements described below. 1. The purchasing department of a company issues purchase orders (PO) to its suppliers. 2. Each PO is for one supplier. 3. Each PO has one or more line-items (PO LINE-ITEM). 4. Each line item belongs to one PO, 5. Each line item is for one product from a supplier 6. A supplier may supply one or more products. 7. A product from a supplier could be in multiple purchase orders. 8. The status of a PO is tracked at the line item level. Example of statuses are "line item shipped", "line item received", "line item rejected", "line item paid", etc

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!