Question: SQL Database. Desperatly need help finishing this assignment. I need help with the remainder of quesitons 19-25. Below is a link to whats been answered
SQL Database. Desperatly need help finishing this assignment. I need help with the remainder of quesitons 19-25. Below is a link to whats been answered so far. I had to break it it up.
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
19. List the ship name, size, and service entry date of the largest ship (greatest size). The query should return one row of data. You may not provide any specific values in the WHERE clause (e.g., 'WHERE ship_size = 142000' is not permitted.)
20. Passenger 48596 has paid the remaining balance on his reservation on cruise #5. Make the appropriate change to the database.
21. Cruise #1 has been cancelled, due to hurricane danger. Do what is necessary to delete this cruise and the associated reservations from the database. (In a production database, such an event would not cause data to be deleted; rather, the cruise would be marked as cancelled in some way. But this isnt a production database, and we need to practice deleting data, so. )
22. Add a constraint to the Ship table to limit the Ship_Lifestyle values to: Contemporary, Premium, Luxury.
23. Create a view that displays the passenger name, telephone number, and balance due for those passengers who have a positive balance due.
24. For each ship, list the departure date and departure city of that ships cruise(s) with the longest duration. (There should be one row for each ship that is used for a cruise.)
25. Create an index on the Ship_Name column in the Cruise table.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
