Question Normalisation - pic

ipwn

Registered User.
Local time
Yesterday, 23:47
Joined
Mar 9, 2009
Messages
10
I'm stuck on the normalisation part.

Can anyone explain the 3 forms of it and how you go about doing it.

I can't tell if my data is already normalised before I even tried to normalise them

I took a screenshot of how my tables and relationships are currently

46770083.jpg



Thanks alot for any help offered.

Its for a car rental database btw, categories table contains the price for each car category, and the service price is the price that the service of the car cost.
 
I suggest that you Google Normalization. Use a "z" rather than a "s"

A couple of hints.

Name and Date are reserved words so use something like CatName not Name and myDate not Date.

You have "Price" in three tables. Is this the same data. If not then make Price more descriptive like RentalPrice etc.

Use a naming convention for your tables. Suggest you start with a prefix of tbl TblCars and tblCustomers is much better. This will avoid confusion with queries. Because queries will show up in some lists together with tables.

Prefix your queries with qry, Forms with frm and reports with rpt. It just helps a little.

Your Primary keys and Foregin keys should have better naming conventions also.
If you are going to use id then use the same for both Primary key and Foregin key.

Alternatively you can use CarPK and CarFK. And so on.

Hope this helps a little.
 

Users who are viewing this thread

Back
Top Bottom