For each of the following questions, design a schema in the E-R model including entity types, relationship types and attributes,

computer science

Description

For each of the following questions, design a schema in the E-R model including entity types, relationship types and attributes, select a primary key or a partial key for each entity type, express the schema as an E-R diagram in the notation we are using, and then transform the schema into the relational model (and select a primary key for each relation). A relation schema should be expressed in the form of R(A1, A2, ..., An) where R is relation name and A1, A2, ..., An are attribute names. Underline the attribute(s) in the primary key of a relation. Data types, domains, and constraints of attributes are NOT required to include in the relational schema. Submit an e-copy of your work. You may hand-draw and scan, or draw using a software tool.

Question 1 (4%)

 Design a database schema for an auto service department. The database stores information about vehicles, customers, services and mechanics. For a vehicle, the plate number, make, model, and year are stored. For a customer, the name, address and phone number are stored. For a service, the date-time, service details, and the mechanic who conducts it are stored. For a mechanic, the name, date of birth, and license number are stored. A customer may own one or many vehicles. A vehicle may be owned by one or more customers. A service is for a vehicle and a vehicle may have many services. A service is conducted by a mechanic.

Instruction Files
A13530.pdf
28.4 KB

Related Questions in computer science category