Design a normalized order management database with the requirements provided in the MS Excel worksheet( COMPLETE THE ASSIGNMNET ON THE PROVIDED ATTACHMENT).
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.
Baltzan, P. & Philips, A. (2020). Business driven information systems (7th ed.). McGraw-Hill