draw ER diagram following scenario Mobile responsive web app & mobile apps (Android / iOS) required to maintain service records of customer vehicles at ABC Ltd vehicle car service center. This system should be able to store all customer vehicle information & service records, schedule appointments, search past customer service records. Super Admin should have access to manage all customers, vehicles, service records, create service agents for the company. Service Agents will have a login & able to create, edit, delete, service records for customers. Service records should include the following information in general. Service ID, Service Category, Customer ID, Vehicle ID, Date/Time, etc. Service agents can see daily appointments & Approve or Reject appointments. Service agents should be able to search through past appointments, customers, customer vehicles, service records of vehicles, etc. The customer should be able to register from the app. They can add vehicles, edit, and delete vehicles. View service records of their vehicle. Create a new appointments for vehicle services. An appointment should include Appoinmement ID, Vehicle ID, Service Category, and Schedule Date/Time. Make online payments for service appointments once the job is done.
draw ER diagram following scenario
Mobile responsive web app & mobile apps (Android / iOS) required to maintain service records of customer vehicles at ABC Ltd vehicle car service center. This system should be able to store all customer vehicle information & service records, schedule appointments, search past customer service records.
Super Admin should have access to manage all customers, vehicles, service records, create service agents for the company.
Service Agents will have a login & able to create, edit, delete, service records for customers. Service records should include the following information in general. Service ID, Service Category, Customer ID, Vehicle ID, Date/Time, etc. Service agents can see daily appointments & Approve or Reject appointments. Service agents should be able to search through past appointments, customers, customer vehicles, service records of vehicles, etc.
The customer should be able to register from the app. They can add vehicles, edit, and delete vehicles. View service records of their vehicle. Create a new appointments for vehicle services. An appointment should include Appoinmement ID, Vehicle ID, Service Category, and Schedule Date/Time. Make online payments for service appointments once the job is done.
Step by step
Solved in 2 steps with 1 images