Question: CAR SERVICING CENTER DFD and ER Diagram Create a DFD (Context and Level 0) for a Car Servicing Center. Model the login process for walk-in

CAR SERVICING CENTER DFD and ER Diagram Create a

CAR SERVICING CENTER DFD and ER Diagram Create a DFD (Context and Level 0) for a Car Servicing Center. Model the login process for walk-in customers. These customers can be "new" or existing. All new customers must be first registered. Each customer may own multiple vehicles, and all vehicles need to be assigned to a Mechanic based on schedule and availability. Each vehicle may have one or more service requests. Some services might require ordering of parts from a supplier. Post servicing, the customers will make payments, as needed. All service requests are stored such that Management can review periodic reports for performance evaluation. Create an ER diagram for the above problem. Identify the main entities: Customer {Customer_ID, FName, LName, Address, Phone#} Vehicle {Vehicle_ID, Model, Make, Miles} Mechanic {Mechanic_ID, MName, Salary} Service {Service_ID, Service Name, Service_Duration, Service_Rate} Parts {Part_Id, Part_Name, Part_Size, Part_Category, Part_quantity} Supplier Invoice

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!