WEEK 5

Draw A Complete ER Diagram for the following :

A.) A customer reserve a data for maintenance or repairs to a vehicles. The reservation is given a reservation number, customer id, and vehicles no, are recorded with reservation.The time of reservation is also recorded.

B.) Information stored about customer includes customer id, customer name, address, and telephone no.

C.) Information kept about the vehicles includes vehicles no, make Reg No and Date of Manufacturer

D.) After examination, a number of job are recorded for the vehicles. Each job has a job no, within the booking, and the reasons for carrying out the job are recorded as why-needed.

E.) The pairs used for each job and time on each job are also recorded

F.) The information about part includes Part No and Price

…………………………………………………………………………………

Step

1. Find the entities

2. Sketch ERD

3. Relationship

4. Cardanality Constraint

5. Attribute

6. Primary Key/ Foreign Key

Entities

1. Custom ( customer_id , customer name, address, and telephone_no )

2. Vehicles ( vehicles_no , make , Reg_No , and Date of Manufacturing )

3. Reservation (reservation_no , customer_id , vehicles _no , time of reservation)

4. Job (job_no and why_needed)

5. Part (part_no , price, and time_spent)