Normalized order management database | Information Systems homework help

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

Logically selected entities, attributes, and all unique identifiers.        60

Logically identified relationships between entities.       40

Logically laid out individual database records.              50

Logically identified primary key fields for each table.    30

Labeled the general layout.           20

Total   200

Need this to be in APA format with in-text citations and no wiki websites, please.