Garage Scenario
Normalisation
A car repair database
Scenario
A local garage is becoming busier and they have decided they need a more effective way of recording customer
details, cars and repairs.
They currently have a job card as you can see below.
Customer Name
TopTech Customer Address
Garages’R’Us Customer Phone
Car Reg Make Model Colour Mileage Fuel Engine Size
Any existing Damage
Job Details Date Booked In
Symptoms reported
Fault identified
Remedy
Parts Used
PartNo Part Description Part Cost
1. Produce a normalised design of the data structure of the database. You should clearly identify which are
key fields, which are foreign keys etc.
2. Identify the data types and sizes (where appropriate) for each of the attributes.
Normalisation
A car repair database
Scenario
A local garage is becoming busier and they have decided they need a more effective way of recording customer
details, cars and repairs.
They currently have a job card as you can see below.
Customer Name
TopTech Customer Address
Garages’R’Us Customer Phone
Car Reg Make Model Colour Mileage Fuel Engine Size
Any existing Damage
Job Details Date Booked In
Symptoms reported
Fault identified
Remedy
Parts Used
PartNo Part Description Part Cost
1. Produce a normalised design of the data structure of the database. You should clearly identify which are
key fields, which are foreign keys etc.
2. Identify the data types and sizes (where appropriate) for each of the attributes.
