Database Managment System Question Bank
2) Design a generalization - specification hierarchy for a MOTOR-VEHICAL sales company. A company sales motorcycle, cars, vans, buses. Justify your placements of attributes at each level.
3) Construct an E-R diagram for a Hospital with a set of patients & a set of Medical Doctors. Associate with each patient a log of various tests and examinations conducted.
4) Give differences between following…
a. Physical & Logical independence
b. Schema & Sub Schema
c. Operational data & Transient data
d. Relation & Relation schema
e. Pipelining & Materialization