Database Management System Course

Course : Database Management System

Database Management For Business

Draw An ER Diagram

Toyota company wants to keep record of all the cars it makes. Each car has a VIN number, color, and a manufacturing completion date. Each car represents exactly one car model, all of which have an identification number and a name. In addition, the company wants to maintain information about the designer of the model such as designer ID, name, and phone numbers. Over time, the company often manufactures thousands of cars of a certain model. The technicians in the company are responsible for inspecting the cars before they are shipped to the customers. Each car is inspected by at least one technician (identified by their employee number, emails, and phone numbers). For each separate inspection, the company needs to record its date and the evaluation status. The car technicians have a hierarchy of reporting relationships: some of them have supervisory responsibilities in addition to their inspection role and have multiple other technicians report to them. Toyota company covers the health insurance for the dependents of each technician. The dependent is identified by his/her first and last name, gender, and date of birth. The company covers up to 3 dependents for each technician. Toyota company wants to keep record of all the cars it makes. Each car has a VIN number, color, and a manufacturing completion date. Each car represents exactly one car model, all of which have an identification number and a name. In addition, the company wants to maintain information about the designer of the model such as designer ID, name, and phone numbers. Over time, the company often manufactures thousands of cars of a certain model. The technicians in the company are responsible for inspecting the cars before they are shipped to the customers. Each car is inspected by at least one technician (identified by their employee number, emails, and phone numbers). For each separate inspection, the company needs to record its date and the evaluation status. The car technicians have a hierarchy of reporting relationships: some of them have supervisory responsibilities in addition to their inspection role and have multiple other technicians report to them. Toyota company covers the health insurance for the dependents of each technician. The dependent is identified by his/her first and last name, gender, and date of birth. The company covers up to 3 dependents for each technician. Q1. Draw an entity relationship diagram for the following situation: Toyota company wants to keep record of all the cars it makes. Each car has a VIN number, color, and a manufacturing completion date. Each car represents exactly one car model, all of which have an identification number and a name. In addition, the company wants to maintain information about the designer of the model such as designer ID, name, and phone numbers. Over time, the company often manufactures thousands of cars of a certain model. The technicians in the company are responsible for inspecting the cars before they are shipped to the customers. Each car is inspected by at least one technician (identified by their employee number, emails, and phone numbers). For each separate inspection, the company needs to record its date and the evaluation status. The car technicians have a hierarchy of reporting relationships: some of them have supervisory responsibilities in addition to their inspection role and have multiple other technicians report to them. Toyota company covers the health insurance for the dependents of each technician. The dependent is identified by his/her first and last name, gender, and date of birth. The company covers up to 3 dependents for each technician