Sorry! We could not find what you were looking for
Try going back to the main page here
CMSC 461: Database Management Systems
Homework 1, Fall 1998 Due: 22 September 1998
Make sure that your name, SSAN, and section number are
included on every page!
Make sure your work is neat and
easy to read. If we can not read it, it is wrong!
- Construct an E-R diagram for a university registrar's office. The office
maintains data about each class, including the instructor,
the enrollment, and the time and place of the class meetings.
For each student-class pair, a grade is recorded. Document all
assumptions that you make about the mapping constraints.
- Construct an E-R diagram for a car-insurance company that has a
set of customers, each of whom owns one or more car. Each car has
associated with it zero to any number of recorded accidents.
- Construct an E-R diagram for a hospital with a set of medical
doctors. Associate with each patient a log of the various tests and
examinations conducted.
- Construct appropriate E-R schemas for each of the above diagrams.