Desperate and need help finishing this Assignment. Below is a link to whats been

Question

Desperate and need help finishing this Assignment. Below is a link to whats been answered so far.

https://www.chegg.com/homework-help/questions-and-answers/desperate-need-help-sql-developement-pay-done-father-passed-away-last-week-got-backt-town--q28378885

Need questions 3-10

3. List the name, size, passenger capacity, and crew capacity of each ship.

4. List the names and registry of all ships with a “Contemporary” lifestyle.

5. List the Cruise ID, the departure date, and ship name for all cruises departing from Miami.

6. List the Cruise ID, departure date, and departure city of all cruises longer than 5 days in duration.

7. List the name and registry of all ships used in a cruise that departs from Miami. (Use the IN + subquery construct.)

8. List the name of all passengers with a reservation on a cruise that departs from Miami. (Use the IN + subquery construct.)

9. List the name of all passengers who have requested a Vegetarian diet on a cruise. Include the name of the ship in query output. (Do a join.)

10. List the names of all passengers with a reservation on a cruise that departs from Miami on 25-May-15. Include the name of the ship in the query output. (Do a join.)

Explanation / Answer

3.

Select Ship_Name,Ship_Size,Ship_PassCapacity ,Ship_CrewCapacity from SHIP;

4.

Select Ship_Name,Ship_Registry from SHIP where Ship_Lifestyle = 'Contemporary';

5.

Select Cruise_ID,Cruise_DeptDate,Ship_Name from CRUISE where Cruise_DeptCity = 'Miami';

6.

Select Cruise_ID,Cruise_DeptDate,Cruise_DeptCity from CRUISE where Cruise_Duration > 5;

7.

Select Ship_Name,Ship_Registry from SHIP where Ship_Name IN ( Select Ship_Name from CRUISE where Cruise_DeptCity = 'Miami');

8.

Select Pass_Name from PASSENGER ,RESERVATION where PASSENGER.Pass_ID = RESERVATION.Pass_ID and RESERVATION.Cruise_ID IN(Select Cruise_ID from CRUISE where Cruise_DeptCity = 'Miami');

9.

Select Pass_name,Ship_Name from PASSENGER inner join RESERVATION on PASSENGER.Pass_ID = RESERVATION.Pass_ID ?inner join CRUISE on CRUISE.Cruise_ID = RESERVATION.Cruise_ID where Res_SpecialRequest = 'Vegetarian';

10.

Select Pass_name,Ship_Name from PASSENGER inner join RESERVATION on PASSENGER.Pass_ID = RESERVATION.Pass_ID ?inner join CRUISE on CRUISE.Cruise_ID = RESERVATION.Cruise_ID where ?Cruise_DeptCity = 'Miami' and Cruise_DeptDate = '25-May-2015';

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

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