Auto Repair Management System III Entity Relationship and

Auto Repair Management System III. Entity Relationship and Program Design Done by Alan Korulla William Hellela

Contents • Business Need • Data Structure • Entity Relationship Diagram – Logical Design – Physical Design • Program Design – Structure Charts (Module 0, 2)

Business Need • This project has been initiated to provide an automated computerized system for QAMC • The new system helps managing appointments which are now made online by the customer. • This system requires a customer login process which allows access to their service history. It also has the capability of updating and registering new customers. • Additionally, the system generates reports to the management and also sends service confirmations and reminders to the customer.

Physical Design LOGIN Cust. ID (PK) Username Password SCHEDULE Schedule. ID (PK) Service. ID (FK) Vehicle. ID (FK) Sch_Date Sch_Start Sch_End CUSTOMER Cust. ID (PK) Cust_lname Cust_fname Cust_Address Cust_City Cust_State Cust_Zip Cust_phone Cust_email FEEDBACK FBID (PK) Cust. ID (FK) FB_Onlinesys FB_Service FB_Overall. Satis FB_Cleaniness FB_Recommend VEHICLE Vehicle. ID (PK) Cust. ID (FK) Veh_Year Veh_Make Veh_Model Veh_VIN Veh_Lic. Plate SERVICE Service. ID (PK) Serv_name Serv_cost Serv_time

Auto Management System

The End Any Questions