Greetings again experts.
I have some doubts I need your expertise on.
I have a lookup table called EquipmentType with the following attributes:
**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.
Table = Aircraft
Table = Boats
Table = Cars
OR is it better to just have a bridging table with the following attributes:
This way, we would not have EquipmentTypeID on any of the equipments.
Can I please get your thoughts on this?
Many thanks in advance