Question: Section 2: This section covers database design and ER diagrams (50 points). (A.1) Construct an ER diagram for a car insurance company that maintains data

 Section 2: This section covers database design and ER diagrams (50

Section 2: This section covers database design and ER diagrams (50 points). (A.1) Construct an ER diagram for a car insurance company that maintains data on customers who may own more than one car. The company also keeps track of the accidents that the customer has been in and the damage cost. Each entity has at most 3 attributes (23 points). (A.2) Using the ER diagram you have created, define the relational schema and with attributes and domains. (12 points) (B) Construct an ER diagram for a university with undergraduate, post-graduate, and PhD students that have a student id, name, and date of birth. These students belong to a college that has a name and departments. Undergrads have a major and a minor. Post-grads have a teaching (TA) assignment. PhD students have a research assignment (RA). (15 points)

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!