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.
