Question:

This form represents one of a number used for each sailing of a range of boats. A passenger may go on many sailings and will have the same passenger number for each. The cruise fee varies according to the sailing details (e.g. date of sailing).

(a) Represent the form as a relational schema and Normalize to third normal form, using dependency diagrams to justify decomposition steps. Show all the partial and transitive dependency in your diagram.

(b) Draw an ERD of the system from the tables obtained from the normalization process.