asked on

Normalization problem

Hi,
I am working on the vehicle details normalization but I am not sure it is correct or not. could you check it for me please? -we have: vehicle make, manufacturer, model, colour, type, fuel, year and safety.
I have no idea about year and safety . Thanks for your help.

manufactures(manufactur_id, manufactur_name, manufactur_address, manufactur_website)

vehicle_model(model_id, model_name, manufactur_id(fk))

vehicle_colour(colour_id,colour)

fuel(fuel_id,fuel_type)

type(type_id,type_description)

(year,safety)

vehicle(vehicle_id, colour_id(fk), model_id(fk), fuel_id(fk), type_id(fk), ......)

Mike Eghtebas

vehicle_model(model_id, model_name, year, manufactur_id(fk))

Give some sample data for safety

If safety is a list of safety options, then add two new tables called SafetyOption and a bridge table called VehicleSafety.

SafetyOption (Safety_id(PK), SafetyDesc)
VehicleSafety(vehicle_id(fk), Safety_id(FK))

Mary sharry

ASKER

Hi Mark, it is a sample data

•      Vehicle make (e.g. Honda, Subaru, Jeep)
•      Manufacturer representative(contact and website)
•      Vehicle model
•      Colour
•      Type (e.g. saloon, hatch, SUV, truck)
•      Fuel type (e.g. petrol, diesel, electric, hybrid, bio …)
•      Year (e.g. 1989, 1956)
•      Safety Rating (e.g. Honda Civic has a safety rating of 4/5, Subaru Legacy a rating of 3/5 and so on)

Mike Eghtebas

That make it much simpler:

vehicle_model(model_id, model_name, year, saftyRating, manufactur_id(fk))

Mary sharry

ASKER

what about the other tables that I made? do you think all are correct?

Mike Eghtebas

Oh, I just sent you an email on that. I will review other tables early in the morning.

Mike Eghtebas

type(type_id,type_description, year, saftyRating)

The same car could have different saftyRatings for the year depending on its type.

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.