When we think about Cruise Ships, we think firstly about Cruises, Ships, Passengers, Places where the cruises go to,
and then we think about the Staff, booking Tickets and so on.
So we end up with this draft list that provides our starting-point for designing the Data Model ...
Then we think about how these various things are related, and how they might look on a 3NF Normalised Data Model.
For example, Passengers book Tickets to go on Cruises.
Ship are used to run Cruises and visit a number of Ports from a Master List.
A Cruise will have a Schedule for visiting ports.
Every Passenger must be allocated to a Room (or Cabin) and some may share a Room.
More details are provided on the The Specifications page.