Database Design and Implementation

****Using the digram below CREATE A RELATIONAL SCHEMA****

Create a Word document for your answers:

***CREATE A RELATIONAL SCHEMA***

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

--------------------------------------------------------------------------------------------------------------------------

Below you will see a snip of what I have came up with so far for Part A: I need help with completing this RELATIONAL SCHEMA. I need help with connecting them with arrows to link each one to the other. I also need help with taking into account for the special attributes (composite, derived, multivalued) that can be found in the main ER digram above.

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 PART A: Customer Cust ID First N Last N Street City State Zip PassportNum Transaction Transaction_ID Amount Date Cruise Cruise ID DeparturePort Cost Sail Date Return_date Length Room Type RoomType ID Capacity Window Balcony BedType Amenities