Question 2 please

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. Customercard Cut Expiration Security Code Nane First, Address the Passport Port Country CrossTown Crowd + Date 04 + Cesta Departure fort Salute Reture euro Room + Description Cost De Active ME Floor Cost 1. Please model the following entities taking care to account for any special attributes (composite, derived, multivalued) you might encounter. a. Customer b. Transaction c. Cruise d. RoomType 2. Please model the following relationships taking care to account for any special attributes (composite, derived, multivalued) you might encounter. a. Customer-CustomerCard b. Destination-Cruise c. CustomerCard-Transaction Reservation What to turn in Word document in the Folio Dropbox for this assignment with your Name the file M4-Assign1.docx. Turn in the single Word document in the Folio Dropbox for this assignment. Do not zip. ver