Scribd
Upload
1K views11 pages

Car Insurance E-R Diagram Construction

The document describes several example entity-relationship diagrams for different scenarios: 1) A car insurance company with customers who own multiple cars, where each car can be associated with zero or more recorded accidents. 2) A hospital with patients and doctors, where each patient has a log of tests and examinations conducted and doctors are associated with patients and tests. 3) Kathmandu Engineering College's data on courses, course offerings, students, and instructors where students enroll in courses and are awarded grades.

Uploaded by

bipin bam
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
1K views11 pages

Car Insurance E-R Diagram Construction

The document describes several example entity-relationship diagrams for different scenarios: 1) A car insurance company with customers who own multiple cars, where each car can be associated with zero or more recorded accidents. 2) A hospital with patients and doctors, where each patient has a log of tests and examinations conducted and doctors are associated with patients and tests. 3) Kathmandu Engineering College's data on courses, course offerings, students, and instructors where students enroll in courses and are awarded grades.

Uploaded by

bipin bam
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
  • Chapter 2 Questions
  • E-R Diagram for Car Insurance Company
  • E-R Diagram for Hospital
  • E-R Diagram for Kathmandu Engineering College
  • Closing Note

Chapter 2

Questions
Questions
 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.
 Assumption:
Customers have one or more cars each
Each car is associated with zero to any number of
accidents recorded
Question
 Car insurance tables:
person (driver-id, name, address)
car (license, year, model)
accident (report-number, date, location)
Participated (driver-id, license, report-number,
damage-amount)
ER diagram of Car Insurance Company
Questions
 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.
 Assumption:
Questions
Hospital tables:
patients (patient-id, name, insurance, date-admitted,
date-checked-out)
doctors (doctor-id, name, specialization)
test (testid, testname, date, time, result)
doctor-patient (patient-id, doctor-id)
test-log (testid, patient-id) performed-by (testid,
doctor-id)
ER Diagram of Hospital
Question
 Draw the ER diagram of following case.
Kathmandu Engineering college maintains data about the
following entities: (i) Courses, including number, title,
credits, syllabus and prerequisites; (ii) Course offering,
including course number, year, semester, section number,
instructor(s), timings and classroom; (iii) Student, including
student-id, name, address and program; and (iv) instructors,
including identification number, name, department, course
taken. Further, the enrollment of students in courses and
grades awarded to students in each course they are enrolled
for must be appropriately modeled.
Answer
 The main entity sets are student, course, course-offering, and
instructor. The entity set course-offering is a weak entity set
dependent on course.

The assumptions made are :


A class meets only at one particular place and time. This E-
R diagram cannot model a class meeting at different places
at different times.
There is no guarantee that the database does not have two
classes meeting at the same place and time.
ER Diagram of KEC

E-R model of KEC


Thank You

Chapter 2 Questions
Questions Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has assoc
Question Car insurance tables: person (driver-id, name, address) car (license, year, model) accident (report-number, date
ER diagram of Car Insurance Company
Questions Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each p
Questions Hospital tables: patients (patient-id, name, insurance, date-admitted, date-checked-out) doctors (doctor-id, na
ER Diagram of Hospital
Question Draw the ER diagram of following case. Kathmandu Engineering college maintains data about the following entities: (
Answer The main entity sets are student, course, course-offering, and instructor. The entity set course-offering is a weak
ER Diagram of KEC E-R model of KEC

You might also like