Question: ERD Practice 3. A company needs a database to track the following. - Painters - Projects - Teams - Customers Business rules: - Painters work

ERD Practice 3. A company needs a database to

ERD Practice 3. A company needs a database to track the following. - Painters - Projects - Teams - Customers Business rules: - Painters work on Projects - Teams consist of Painters - Customers contract Projects - Customers can request specific teams 1. Based on the diagram in Practice 2. Create an ER Diagram to break apart the Many to Many Relationships. 2. Create a table for each entity listing 25 attributes 3. Assign Primary and Foreign Keys where necessary. Bring all three practices to class on 4/4 to hand in for a grade

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 General Management Questions!