[SOLVED] Database systems Homework #1

Exercise on database design
A company that owns cruise ships wants to design a database for managing scheduled cruises and related services offered by its ships.
• Each cruise ship of the company is identified by the ship code and characterized by name, capacity (number of passengers who can be accommodated), and size (height, width, and depth). Each cruise ship is also characterized by the list of types of cabins available.
• Every cruise ship offers on-board commercial services, which are available to passengers to spend their free time. Every commercial service is characterized by name, category of sold items, and identification number.
1. Describe the conceptual schema of a database for the above application by means of an ER diagram.
2. Derive a normalized relational logical schema for the same database.