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 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
Get step-by-step solutions from verified subject matter experts
