Need some help with SQL Select Commands? I managed to answer most of them, but n

Question

Need some help with SQL Select Commands?

I managed to answer most of them, but need a little help on the last 4. Thanks!

1. Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A "cruise" is a particular sailing of a ship on a particular date. For example, the seven-day journey of the ship Pride of Tampa that leaves on June 13, 2011, is a cruise. Note the following facts about this environment. • Both ship number and ship name are unique in the SHIP Table. A ship goes on many cruises over time. A cruise is associated with a single ship. • A port is identified by the combination of port name and country. As indicated by the VISIT Table, a cruise includes visits to several ports and a port is typically included in several cruises. • Both Passenger number and Social Security Number are unique in the PASSENGER Table. A particular person has a single Passenger number that is used for all the cruises she takes. The VOYAGE Table indicates that a person can take many cruises and a cruise, of course, has many passengers. SHIP Table SHIPNUM SHIPNAME BUILDERLAUNCHDATE WEIGHT CRUISE Table CRUISENUMSTARTDATE ENDDATE DIRECTOR SHIPNUM

Explanation / Answer

j:

k:

l:

m:

Please check the date format and change accordingly.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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