Question: Below is a preliminary entity relationship ( ER ) data model for a stationary sales database. Extend and modify the ER data model using Crow's

Below is a preliminary entity relationship (ER) data model for a stationary sales database. Extend and modify the ER data model using Crow's foot notation; create
appropriate identifiers and attributes for each entity. Explain how you went from first normal form (1NF) to second normal form (2NF) and how you achieved third
normal form (3NF). Lastly justify the decisions that you make regarding minimum and maximum cardinality.
PURCHASE ITEM is
ID-Dependent on PURCHASE
 Below is a preliminary entity relationship (ER) data model for a

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 Databases Questions!