Question: See assignment below: Overview: This activity is meant to support you as you begin the database design process. An ERD is the most common visual

See assignment below:

 See assignment below: Overview: This activity is meant to support you

Overview: This activity is meant to support you as you begin the database design process. An ERD is the most common visual used in the database design process; this activity allows you to draw an ERD based on a set of entities and attributes. Prompt: Using Visio and crow's foot notation, design an ERD that uses the entities and attributes noted in the below table. Be sure you correctly notate the entity name, the attribute name, the key fields (primary and foreign), and relationships on your ERD Customer Order OrderDetail Product Employee OrderlD (PK) (FK) OrderDetail (PK) ProductID (FK) Qty OrderlD (PK) ProductID(PK) EmployeelD (PK) EmployeeLastName EmployeeFirstName CustomerlD (PK) CustomerLastName OrderDate ProductDesc CustomerFirstName CustomerlD (FK) CustomerStreet1 CustomerStreet2 CustomerZip ProductWeight EmployeelD (FK) ProductPrice

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!