Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started