| ORDER MANAGEMENT | ||||
| Entity-Relationship | ||||
| ITEM: | ||||
| Customer Header | ||||
| · customer number | ||||
| · buyer name | ||||
| · bill-to address | ||||
| · buyer phone | ||||
| · buyer email | ||||
| · credit rating | ||||
| Customer Shipping | ||||
| · location number | ||||
| · receiver name | ||||
| · receiver phone | ||||
| · receiver email | ||||
| · ship-to address | ||||
| Order Header | ||||
| · order number | ||||
| · order date | ||||
| · shipment method | ||||
| Order Detail | ||||
| · item number | ||||
| · part number | ||||
| · unit price | ||||
| · total quantity | ||||
| Delivery Schedule | ||||
| · delivery number | ||||
| · location number | ||||
| · quantity | ||||
| · due date | ||||
| Part | ||||
| · part number | ||||
| · standard price | ||||
| Customer-Part Relationship | ||||
| · customer number | ||||
| · part number | ||||
| · special price | ||||
Design a normalized order management database with the requirements provided in the MS Excel worksheet.
Each record should have at least one primary key field specified. After identifying the records and their corresponding fields, draw an entity-relationship (ER) diagram using the MS Excel worksheet to illustrate the relationships between entities and attributes.
See attachment
Assignment 2 Grading Criteria
Maximum Points
Maximum Points
Logically selected entities, attributes, and all unique identifiers.
60
60
Logically identified relationships between entities.
40
40
Logically laid out individual database records.
50
50
Logically identified primary key fields for each table.
30
30
Labeled the general layout.
20
20
Total
200
200
Need this to be in APA format with in-text citations and no wiki websites, please.
Jermaine Byrant
Nicole Johnson
OVER
RATING
YEARS
