Answered: Question 1: Consider the following…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Question 1: Consider the following relational database schema used to keep track of Ship cruise details.
Ships (ShipID, Ship_Name, Manufacturer)
Cruises (CruiseID, CruiseName, ShipID, Start_date, End_date )
Rooms (RoomID, ShipID, RoomName, Type, Price)
Passenger_Reservation(ReservationID, CruiseID, PassengerID, RoomID)
Passenger (PassengerID, SSN, Name, Gender, Age)
Ports (PortName, PortID, City)
Cruise_stay_at_Ports(CruiseID, PortID)

Write down relational expressions for the following queries.

1. For the cruise named “Crex” retrieve the list of ports it includes. Output:CruiseID,PortID,PortName.
2. Print name of the Ships along with the name of the cruises it offered.
3. List the names of all female passengers age less than 20 years who have reserved a room.

4. Find the cruises that are less than 10 days long.

Expert Solution