Just thought I would see what peoples thoughts are on this...
*Thinks up example*
lets say you had a database/model with with 4 different tables/entities...
car boat plane train
And you add 0 or many String/varchar descriptions to each of them, would you have...
1. Description table/entity with 4 columns for the FKs and if it was for a car you would have the FK in a car column and the other 3 columns would be null.
Or would you have
2. 4 different tables/entitys CarDesc, BoatDesc etc.
The descriptions are just strings/varchars.
*Thinks up example*
lets say you had a database/model with with 4 different tables/entities...
car boat plane train
And you add 0 or many String/varchar descriptions to each of them, would you have...
1. Description table/entity with 4 columns for the FKs and if it was for a car you would have the FK in a car column and the other 3 columns would be null.
Or would you have
2. 4 different tables/entitys CarDesc, BoatDesc etc.
The descriptions are just strings/varchars.
Comment