Scribd
Upload
12 views2 pages

E-R Diagrams and SQL for Insurance & Hospital

The document outlines the construction of E-R diagrams for a car-insurance company and a hospital, detailing the entities and their attributes. It specifies the relationships between customers, cars, accidents, patients, tests, and doctors. Additionally, it requests the creation of corresponding SQL tables for both scenarios.

Uploaded by

Abhijeet Ghatol
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views2 pages

E-R Diagrams and SQL for Insurance & Hospital

The document outlines the construction of E-R diagrams for a car-insurance company and a hospital, detailing the entities and their attributes. It specifies the relationships between customers, cars, accidents, patients, tests, and doctors. Additionally, it requests the creation of corresponding SQL tables for both scenarios.

Uploaded by

Abhijeet Ghatol
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Q.

1 A) Construct an E-R diagram for a car-insurance company whose customers own one or more cars
each. Each car has associated with it zero to any number of recorded accidents.
Person (Driver-id, Address, Name)
Car (License, Model, Year)
Accidents (Report-Number, Location, Date)
Q. 1 B) Create Above Tables in SQL.
Q. 2 A) Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors.
Associate with each patient a log of the various tests and examinations conducted.

Patients (SS#, Name, Insurancs, Date_Admitted, Date_Checked_out)


Test (Test_id, Test_Name, Date, Time, Result)
Doctors (Dss, Name, Specialization)
R. 2 B) Create Above Tables in SQL.

You might also like