DATABASE 2 - Ship Company
Interpret the following information related to a small database for a ship company and answer the
questions that follow.
Enterprise rules
Rule 1: Ship information such as Ship Name, Port of Registry, Ship Builder, Building Cost, Number
of Decks, Propulsion, Speed, Passenger Capacity and Number of Crew should be recorded. A ship
can only operate in one region, but if it is being built or under repair it will not be linked to any
region. A region can have many ships however during certain periods no ships might operate in a
region. Region information include; Region Code, Location and Type
Rule 2: Ships have many crew members and for a ship to sail a required number of crew members
are required. Crew members can only work on one ship at a time but it may happen that they are
on a recess period when they will not be working on a ship. Information such as Crew ID, Name,
Surname, Date of Birth, Gender, Country of origin and Passport Number will be recorded.
Instructions
1. Construct an ERD diagram from the enterprise rules above.
2. Write down the database schema entries for all entities available based on the information
made available in the enterprise rules.