A crew (person) could work, over time, on one or many ships.
A ship could have one or many crew (people) working on it.
hi all, this is actually a past year exam question.
Here what I understand:
A ship is assigned to one crew which is the captian. The same captain can be a captain on one or many ships.
One crew is assigned to one ship
haha this is confusing... am i correct?
I have implemented the tables in Mysql.
I found out that i have to create the crew table without declaring ship_id foreign key first. Otherwise I can't input some data into the tables. After I have completed entering the data, I used the alter table command to ship's foreign key to crew's tables.