Greetings again experts.
I have some doubts I need your expertise on.
I have a lookup table called EquipmentType with the following attributes:
EquipmentTypeID
EquipmentType.
Sample data:
**Equipment Type ID** **Equipment Type**
1 Aircrafts
2 Boats
3 Cars
Then I have three tables, Aircrafts, Boats, Cars
My doubt is that I can't seem to decide to decide whether to have EquipmentTypeID as foreign key to each of the equipments.
For instance:
Table = Aircraft
AircraftID
EquipmentTypeID
other attributes
Table = Boats
BoatID
EquipmentTypeID
other attributes
Table = Cars
CarID
EquipmentTypeID
other attributes
OR is it better to just have a bridging table with the following attributes:
BridgeTable
CarID
AircraftID
BoatID
EquipmentTypeID
This way, we would not have EquipmentTypeID on any of the equipments.
Can I please get your thoughts on this?
Many thanks in advance