A car dealer shop decides to store all information about the cars and the technicians by using
Question:
A car dealer shop decides to store all information about the cars and the technicians by using a relational DBMS. Your task is to design an ER model to organize such information. The relevant information is as follows:
• Each car is identified by a registration number. It has the year made, color, number of doors, and a window price.
• Each model is identified by a number. In addition, its capacity, horse power, and mile per gallon need to be recorded.
• Each car belongs to one and only one model.
• A number of technicians are identified by their employee ID. Also, their name, ssn, and salary need to be stored.
• Each technician is certified for one or more model(s).
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart