hey all

i have a 2nd hand book about normalisation with some tutorials, but the answers to the questions are not provide. i was just wondering if any one could normalize the below data so that i can see how it's done.

i know the rules for 1st 2nd and 3rd NF but not sure where to exicute them.

Car Hire paper based un-normalised data below

Garage File:

garage ID
garage name
garage address.

Customer File:

Customer ID
Customer name
Customer address

Driver File:

Driver Employee No
Driver name
Date Joined
Date obtained license

Car File:

Registration No.
Date purchased,
Cost,
Number of seats,

and for each service performed on that car,

garage ID
garage name
garage address
service date
service cost

Hire Agreement File:

showing, for each agreement,
Hire agreement No.,
Customer ID,
Customer name and address,
total no of days hired,
start date,
end date,
total cost of hire

and, for each car in the agreement,

Car registration number
running total of mileage for this car on the agreement
and, for each day of a car on an agreement,
Driver Employee No.
name of the driver.