Question 6 2 pts Given the ERD below which of the following relational designs i

Question

Question 6 2 pts Given the ERD below which of the following relational designs is appropriate? (The primary key is underlined and the foreign key is in italics in the answers.) The ERD models the following: A passenger may take many cruises but he/she must take at least one cruise. A cruise may have many passengers but it must have at least one. PASSENGER CRUISE Has Cruise ID Passenger ID e Departure Takes Arrival First Name Last Name O PASSENGER (Passengerl D, FirstName, LastName CRUISE ruiselD, Departure, Arrival, PassengerfD) PASSENGER CRUISE (Passenger0, Cruisef0) O PASSENGER (Passengerl D, FirstName, LastName CRUISE CruiselD, Departure, Arrival) O PASSENGER (PassengerlD, FirstName, LastName, CnuisefD CRUISE CruiselD, Departure, Arrival, PassengerfD) PASSENGER CRUISE (Passengert0, Cruiser0) O PASSENGER (Passengerl D, First Name, Last Name, CnuisefD CRUISE ruiselD, Departure, Arrival) O PASSENGER (Passengerl D, FirstName, LastName CRUISE CruiselD, Departure, Arrival) PASSENGER CRUISE (Passenger0, Cruiseto)

Explanation / Answer

Question 6:- 4th Option

Question 7:- Foreign Key Column will require unique values and value is required for every row.

Question 8:-    Foreign Key Column will not require unique values and value is required for every row.

Question 9:- Foreign Key Column will not require unique values and value is required for every row.

Question 10:- Foreign Key Column will not require unique values and value is not required for every row.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.