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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

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.

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Fundamentals of Big Data Analytics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education