In Class Lab Assignment #5


AIRPORT DB:
airport(airport, aname, checkin, resvtns, flightinfo),
route(routeno, rdescription),
fares(faretype, fdescription, conditions),
tariff(routeno, faretype, price),
aircraft(aircrafttype, adescription, seatcapacity),
flight(flightno, fromairport, toairport, deptime, arrtime, service, aircraftype, routeno),
passenger(pid, name, address, telno),
ticket(ticketno, ticketdate, pid),
itinerary(ticketno, flightno, legno, flightdate, faretype)

ACTIVITIES:
  1. Create a View that lists the name and telephone of passengers and their ticket numbers (for those passengers with a ticket)
  2. Update table tariff by reducing all prices to 85% of its original amount.
  3. Delete all passengers without a ticket
  4. Create a trigger that displays a warning when inserting a passenger with "666" anywhere in his/her address.