Question: Provide the suitable ERD for the following system (Entity Relationship Diagram) Q5- CRUISE Any assumptions must be explicitly listed . EacMedcruise run cruises on a

 Provide the suitable ERD for the following system (Entity Relationship Diagram)

Provide the suitable ERD for the following system (Entity Relationship Diagram) Q5- CRUISE Any assumptions must be explicitly listed . EacMedcruise run cruises on a range of large ships around the Mediterranean region. These cruises have a name, a duration of 2,3,4,or 5 days, and a cost that varies between 600 and 5000. Each cruise is repeatedly run on different dates along the same standard route that starts at one of four different ports (Athens, Rome, Naples and Nice). These runs are called voyages, and the start date of each voyage, its starting location and its ship are recorded. Customers book on to voyages and Medcruise need to record the customer name, gender, telephone number, and address. Each time a customer takes a cruise, their cabin number and class (First, second, third) is recorded. Customers will also give an evaluation of the cruise (the evaluation is a number from 0 to 4). Medcruise need to record the evaluation from each customer each time they take a cruise. It is not a requirement that all voyages have passengers registered on them, and it is also not required that every customer has to have participated in a cruise. Each ship has a name, a port of registration and gross tonnage (between 25,000 and 60,000 tonnes)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!