Tutorial 8 – ER Model & Database Design

Tutorial 9 – ER Model CSC343 - Introduction to Databases Fall 2008 TA: Lei Jiang Exercise 1 You have been hired to design an RDBMS for the Luxury Limousines Inc. which operates a number of vehicles. The relevant information is given below. - Every vehicle has a registration number and each vehicle is of a specific model; each model is identified by a model number (e.g, LIN-2000) and has a capacity and weight. In addition, the model also has a range (eg. 100 km, 1000 km) associated with it. - A number of technicians work for the company. You need to store the name, SIN, address, phone number and salary of each technician; Each technician specializes in one or more vehicle models. This expertise may overlap with that of other technicians. - The company has controllers who control the incoming and outgoing vehicle traffic in the vehicle areas. As they are exposed to a lot of smoke emissions and also because their job is important, they need to have an annual medical examination. The date of the most recent exam must be stored for each controller. - All company employees including technicians and controller belong to a union. Each employee has a union membership number which must be stored. You can assume that the SIN uniquely identifies each employee. - The company performs a number of checks periodically to ensure that the vehicles are in good condition. These tests are standardized by the Beaureau of Motor Vehicles (BMV) and is identified by a BMV ...