Database Design and Implementation

Create a Word document for your answers:

Part A: Please model the following entities taking care to account for any special attributes (composite, derived, multivalued) you might encounter.

-Customer

- Transaction

- Cruise

- RoomType

PART B: Please model the following relationships taking care to account for any special attributes (composite, derived, multivalued) you might encounter.

- Customer-CustomerCard - Destination-Cruise -CustomerCard-Transaction-Reservation

Introduction Assume you have collected requirements for Eagle Cruise Line and the final agreed upon ER-diagram is provided in the figure below. Therefore, the analysis phase of the project is complete and your team will begin the design phase of the project by completing the logical database design that maps the ER-diagram to a relational schema. To that end, please answer the questions below. Customer Card Customer Destination Number Cust ID Dest ID Type Expiration Security Code Name (First, Last) Address (Street, City State Zip) Passport Num Port Country Description # Ship Ship ID Name Gross Tonnage Capacity Length Crew onboard Transaction Transaction ID + Cruise Reservation (Amount) Date Cruise ID Reservation Num Date Departure Port Cost Sail Date Return_Date [Length] Excursion Room Type Excursion ID Room Type ID Room RoomNum H 1 Capacity Window Balcony Bed Type (Amenities) Title Description Cost Duration Activity Level MinAge Floor Cost Introduction Assume you have collected requirements for Eagle Cruise Line and the final agreed upon ER-diagram is provided in the figure below. Therefore, the analysis phase of the project is complete and your team will begin the design phase of the project by completing the logical database design that maps the ER-diagram to a relational schema. To that end, please answer the questions below. Customer Card Customer Destination Number Cust ID Dest ID Type Expiration Security Code Name (First, Last) Address (Street, City State Zip) Passport Num Port Country Description # Ship Ship ID Name Gross Tonnage Capacity Length Crew onboard Transaction Transaction ID + Cruise Reservation (Amount) Date Cruise ID Reservation Num Date Departure Port Cost Sail Date Return_Date [Length] Excursion Room Type Excursion ID Room Type ID Room RoomNum H 1 Capacity Window Balcony Bed Type (Amenities) Title Description Cost Duration Activity Level MinAge Floor Cost