Help with Normalization

[news.angelfire.ws]

I need some help with normalising. The database will be used for a garage
workshop. So far i have attempted it but am not sure i have fully exhausted
it. This is what i have done so far
Customers table:- Company Name, Title, First Name, Surname, Address1,
Address2, Address3, Address4, Postcode, Home Tel
no., Work No., Mobile No., Other No's., email

Vehicle Details:- Reg No., Make, Model, Engine size, Engine No., Mileage,
Chassis No, Year, Transmission, Pws, Turbo,
A/C, Petrol/Diesel, Radio Code, Mot Due, service Due

Work Done:- Customers Instruction, Report, work carried out

Have i fully exhausted this or can it be normalised further. Any
suggestions will be appreciated. Also any ideas on the invoicing and
crediting tables, do they have to be one table or two seperate tables

Thanks

Sabina

[jahoobob via AccessMonster.com]

You need to place some way to tie these together:
I see a need for CustomerID (AutoNumber PrimaryKey) in the Customer table, a
VehicleID (AutoNumber PK) and CustomerID (ForeignKey) in the Vehicle table
and a WorkID (AutoNumber PK) and VehicleID i(FK) n the WorkDone table.
This way, when work is done, you enter data in the WorkDone table (via a form)
and can use a combo box to select the vehicle based on a query of Customers
and Vehicles. You could use two combos on the form - one that selects
Customer and another that selects the vehicle from the list of those for just
that customer.
news.angelfire.ws wrote:

I need some help with normalising. The database will be used for a garage
workshop. So far i have attempted it but am not sure i have fully exhausted
it. This is what i have done so far

Customers table:- Company Name, Title, First Name, Surname, Address1,
Address2, Address3, Address4, Postcode, Home Tel
no., Work No., Mobile No., Other No's., email

Vehicle Details:- Reg No., Make, Model, Engine size, Engine No., Mileage,
Chassis No, Year, Transmission, Pws, Turbo,
A/C, Petrol/Diesel, Radio Code, Mot Due, service Due

Work Done:- Customers Instruction, Report, work carried out

Have i fully exhausted this or can it be normalised further. Any
suggestions will be appreciated. Also any ideas on the invoicing and
crediting tables, do they have to be one table or two seperate tables

Thanks

Sabina

--
Message posted via http://www.accessmonster.com