Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi I need help with an ER diagram for numer 1 or number 2. 1. Construct an ER diagram for a car insurance company. The

Hi I need help with an ER diagram for numer 1 or number 2.
image text in transcribed
1. Construct an ER diagram for a car insurance company. The customers of the company own one or more cars each. Each car has zero or more recorded accidents. Each insurance policy covers one or more cars and has one or more payments associated with it. Each payment is for a particular period of time, has a due date, and has a payment received date. 2. Construct an ER diagram for a university database, according to the following specifications: - professors have an SSN, name, age, rank, and research specialty - research projects have a project number, sponsor name, starting and ending dates, and a budget - graduate students have an SSN, name, age, department, and degree program - each graduate student has a more senior graduate student as an advisor - each project is managed by one professor - each project is worked on by one or more professors and one or more graduate students - a graduate student's work on a project must be supervised by a professor - professors can work on multiple projects - graduate students can work on multiple projects and may have a different supervising professor for each project - departments have a number, name, and an office - each department has a department chair, that is, a professor who manages the department - professors may work in multiple departments, in which case a time percentage is associated with each department

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Predict the product(s) of this elimination reaction. Br base

Answered: 1 week ago