(Solved): 1. E/R and UML Cruise Ship management database system The following data model is designed to hold ...

1. E/R and UML Cruise Ship management database system The following data model is designed to hold information relating to Cruise Ship database system. For this scenario we need to define the following facts: These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation. Assuming that the Cruise Ships may depart from various different departing Ports and stop at multiple different ports before returning to the departing Ports. the Entities required should include: . · I " The Entities are related as follows: A Traveler may have information such as address, phone, DOB, etc. There are many cruises ships a traveler can board at various departing ports ? ? Travelers Cruise Ships Departing Ports of the Cruise Ships Ports visited by the Cruise Ships (country, city, etc.) Traveler's feedback to the Cruise Ships A Traveler can travel multiple times on Cruises A Traveler may write reviews on certain Cruise Ships. When asking questions of the database we may need to know: 1. Who took which ship departing from which port? 2. Who wrote feedback for which Cruise Ship? . Create an UML diagram capturing the objects and relationships described above. Describe all your design choices and constraints. Please use the notation for UML diagrams introduced in the course. Rubrics used will be similar to the homework Rubrics for grading. Required entity sets Appropriate attributes for all entity sets Correct Relationships (showing multiplicity) Correct keys and foreign keys Correct UML format