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]

Re: Help with Normalization

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:[color=blue]
>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[/color]

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