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,
c.PhoneFROM reservation r,customer cWHERE r.CustomerNum = c.CustomerNum;
You've reached the end of your free preview.
Want to read all 4 pages?
- Fall '17