2.0.1 QUESTION 1

Draw a complete E-R Diagram for the following

A) A customer reserves a date for maintanance or repairs to a vehicle. The reservation is given a Reservation_No, Customer_ID and Vehicle_No are recorded with the reservation. The Time_Of_Reservation is also recorded.
B) Information kept about customer includes Customer_ID, Customer_Name, Address and Telephone_No.
C) Information kept about the vehicle include Vehicle_No, Make, Reg_No and Date_Of _Manufacturing.
D) After examination, a number of job are recorded for the vehicle. Each job has a Job_No within the ing and reasons for carrying out the job are recorded as why needed.
E) The parts ued for each job and Time_Spent on each job are also recorded.
F) The information about parts include Part_No and Price.
    i) Find the entities
    ii) Find the attribute
    iii) Sketch ERD
    iv) Relationship
    v) Cordinalty Constraint
    vi) Attribute
    vii) Primary Key

Entities
1. Customer

• Customer_ID (PK)
• Customer_Name
• Address
• Telephone_No

2. Vehicle

• Vehicle_No (PK)
• Make
• Reg_No
• Date_Of_Manufacturing

3. Reservation

• Reservation_No (PK)
• Customer_ID
• Vehicle
• Time_Of_Reservation

4. Job

• Job_No (PK)
• Why_Needed
  

5. Parts

• Part_No (PK)
• Price
• Time_Spent

ERD