Colonial Adventure Tours Case 4.docx - Colonial Adventure Tours Case 1 Create a view named NHTrips It consists of the trip ID trip name start location

Colonial Adventure Tours Case 4.docx - Colonial Adventure...

This preview shows page 1 - 3 out of 4 pages.

Colonial Adventure Tours Case1.Create a view named NHTrips. It consists of the trip ID, trip name, start location, distance, maximum group size, type, and season for every trip located in New Hampshire (NH). Display thedata in the view.CREATE VIEW NHTrips ASSELECT TripID, TripName,StartLocation, Distance,MaxGrpSize, Type,SeasonFROM tripWHERE State='NH';SELECT * FROM NHTrips;2.Create a view named Hiking. It consists of the trip ID, trip name, start location, state, distance, maximum group size, and season for every hiking trip. Display the data in the view.CREATE VIEW Hiking ASSELECT TripID,TripName, StartLocation, State, Distance, MaxGrpSize, SeasonFROM trip;3.Create a view named ReservationCustomer. It consists of the reservation ID, trip ID, trip date, customer number, customer last name, customer first name, and phone number. Display the data in the view.CREATE VIEW ReservationCustomer2 ASSELECT r.ReservationID, r.TripID, r.TripDate, r.CustomerNum, c.LastName, c.FirstName,
Background image
c.PhoneFROM reservation r,customer cWHERE r.CustomerNum = c.CustomerNum;
Background image
Image of page 3

You've reached the end of your free preview.

Want to read all 4 pages?

  • Fall '17

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture