Database for Car Service Operations

1.

Database
for Car
Service
Operations
Laboratory Projects Overview
Nagashbek Raiymbek
Sauranbayev Alikhan

2.

Overview
This database
contains
information about
car service
operations,
including:
- Customers,
Vehicles,
Services, Service
History, Parts,
Appointments,
Mechanics,
Payments, Reviews,
Promotions

3.

Relationships
- Customers (1) ↔
Vehicles (M): One
customer can have
many cars.
- Vehicles (1) ↔
Service_History
(M): One car can
have many records
in the service
history.
- Services (1) ↔
Service_History
(M): Each service
can be associated
with multiple
service records.
- Parts (M) ↔
Services (M): Each
part can be used
in several
services.
- Customers (1) ↔
Appointments (M):
One customer can
have many
appointments.
- Vehicles (1) ↔
Appointments (M):
One car can be
booked for many
meetings.
- Mechanics (1) ↔
Appointments (M):
One mechanic can
handle many
appointments.
- Mechanics (1) ↔
Service_History
(M) (optional):
One mechanic can
perform many
services.
- Appointments (1)
↔ Vehicle (1): One
appointment
belongs only to
one vehicle.
- Appointments (1)
↔ Payments (1):
Each appointment
has one associated
payment record.
- Customers (1) ↔
Reviews (M): One
customer can leave
multiple reviews.
- Services (1) ↔
Reviews (M): Each
service can have
multiple reviews.
- Promotions (M) ↔
Services (M)
(optional): Many
promotion can be
applied to
multiple services.

4.

Project 2 Visualization
• Created an ER
diagram using
Lucidchart.

5.

Project 3 - Many-to-Many
& 3NF
• Implemented many-tomany relationships by
creating junction
tables.

6.

Projects 45. Physical
Design and
Content

7.

Project 6.
Queries

8.

Conclus
ion
• Developed a
comprehensive
database for car
service management.
• Visualized the
design with
Lucidchart.
• Improved data
consistency with
many-to-many
relationships and
3NF.

9.

thank you for
your attention