ERD Activity

 

 

The local Special Weapons and Tactics team (SWAT) has a collection of motorcycles, and you have been asked to design a database to manage it. The information about the vehicles is given below.

Every motorcycle has a registration number and each motorcycle is of a specific model; each model is identified by a model number (e.g, YU-2000) and has a capacity and weight. In addition, the model also is categorized as bullet proof or not.

SWAT team members must be qualified to use specific motorcycles. Therefore the database must include the SWAT# of each SWAT team member (that will be the only information from the SWAT members to be in the database)

Motorcycle technicians work for the department. You need to store the name, SIN, address, phone number and salary of each technician; each technician is certified to fix one or more motorcycle models. This expertise may overlap within technicians.

SWAT wants to keep a record of motorcycles that have participated in high speed pursuits and shootings.

SWAT has controllers who control the incoming and outgoing motorcycle 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.

SWAT performs a number of checks periodically to ensure that the motorcycles are in good condition. These tests are standardized by the Bureau of Motor Vehicles (BMV) and is identified by a BMV test number. The test also has a name and a maximum possible score.

The BMV requires SWAT to keep track of each time a given vehicle is checked by a given technician using a given test. The information for each testing event is the date, the number of hours spent in testing and the score the vehicle received on the test.

 

(a) Draw an ER diagram for the database. Make sure to indicate the various attributes of each entity and relationship set. Also specify the key and cardinality constraints.

APlusGrades

Not Rated (0)

Status NEW Posted 21 Jul 2017 05:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer