CODEWITHSUNDEEP
databaseentity-relationship
Ryan Rickgauer
Ryan Rickgauer

Reputation: 15

ER Diagram about car rental company

I am generating an ER Diagram about a car rental company that stores information about the cars, their makes, models, and colors. Would I classify the make, model, and colors as separate entities, or as attributes of the car entity?

Upvotes: 1

Views: 1438

Answers (1)

Mureinik
Mureinik

Reputation: 312136

It would make sense if the make, model, and color themselves have attributes (e.g., a color can have attributes like heat retention or reflectiveness). Using the BCNF principles, you wouldn't want to replicate these properties per car, but hold them once per color, and have the different cars reference this color.

Otherwise, if they are just simple properties, it doesn't make much sense to store them as entities on their own right.

Upvotes: 0

Related Questions