Hello there, wonder if you can help me..
I've got to normalise a database, up to 3NF and wonder if you do the normalisation on each individual table, OR the database as a whole?
I've got this so far:
Attributes:
registration_No
Make
Model
Type
Cylinder
Body Type
Transmission
Air Conditioning
Colour
Photo
passenger
The key is registration_No and the functional dependancies are:
registration_No -> {Make, Model, Type, Cylinder, Body Type, Transmittion, Air_Conditioning, Color, Photo, Passenger}
And this table is in: 1NF, 2NF and 3NF..
Does this look ok, or am I doing it wrong?
Thanks :)