Question: 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.

Question 2 please Assume you have collected requirements for Eagle Cruise

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

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!

Assume you have collected requirements for Eagle Cruise Line and the fnal agreed upon ER- diagram is provided in the figure below. Therefore, the analysis phase of the project is complete and your...

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

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,...

Database Design and Implementation ****Using the digram below CREATE A RELATIONAL SCHEMA Create a Word document for your answers: ***Using the digram about CREATE A RELATIONAL SCHEMA*** Part A:...

Database Design and Implementation ****Using the digram below CREATE A RELATIONAL SCHEMA Create a Word document for your answers: ***Using the digram above CREATE A RELATIONAL SCHEMA*** Part A:...

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...

Common Size Balance Sheet Prepare a spreadsheet with common size balance sheets for the years ended November 30, 2014 and 2015. For 2014, each line item should be shown as a percentage of total...

On January 4, 2011, the Federal Circuit Court of Appeals issued an important decision on the determination of reasonable royalties in patent infringement damages. InUniloc USA, Inc. v. Microsoft...

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

JPMA-01726; No of Pages 12 Available online at www.sciencedirect.com ScienceDirect International Journal of Project Management xx (2015) xxx - xxx www.elsevier.com/locate/ijproman Does Agile work? A...

Jane Parker is going to set up a new business on 1 January 20X1. She estimates that her first six months in business will be as follows: (i) She will put 150,000 into a bank account for the firm on 1...

If the current price of a nondividend-paying stock is $32 and a one-year futures contract on that stock has a contract price of $35, explain how an investor could create an "off-market" long position...

Cost - Benefit Analysis ( CBA ) is a fundamental economic framework used to evaluate the viability of hosting major sports events like the Africa Cup of Nations ( AFCON ) . This theory involves...

While investigating suspicious activity on a server, a security administrator runs the following report File system integrity check report Total number of files: 3321 Added files: Removed files:...