Question
The following show the tables and sample data of La Trobe Airline. The PLANE and PILOT tables store the list of planes owned by the
The following show the tables and sample data of La Trobe Airline. The PLANE and PILOT tables store the list of planes owned by the airline and the pilots working there respectively. PASSENGER table stores the information of the passenger flying with the airline. FLIGHT table stores information of the flights. This table includes information about the pilot and plane used. CITY table identifies the city where the airline flies to along with the airport information. PASSENGERFLIGHTS stores the relationship between passenger and flights. These are the ONLY tables in the airline database. NOTE: Primary Key (PK) is underlined, Foreign Key (FK) is printed in italic, PK that is also FK is underlined and printed in italic. PLANE PASSENGER SerialNo Capacity NextServiceDate Name Address PhoneNo ABC100 150 04/08/2022 Jamie Roberts Bundoora 95695687 ABC200 150 05/09/2023 Lily Chan Kew 95821456 ABC300 100 01/09/2023 Duke Gold Mill Park 96582563 ABC400 200 03/08/2022 Harry Nguyen Williamstown 93569282 ABC500 300 01/08/2022 Sonya Taylor Camberwell 95869582 CITY PILOT CityCode CityName State AirportDesc PilotID PilotName MEL Melbourne VIC Large P1 Yuka Yamashita ADL Adelaide SA Medium P1 Matt Green CBR Canberra ACT Medium P2 Bernie Winston SYD Sydney NSW Large P2 Kay Malson PER Perth WA Medium P3 Cliff Marsden FLIGHT FlightNo Date DepTime ArrTime Origin Dest PilotNo SerialNo LAT123 01/08/2022 09:00 10:15 MEL SYD P1 ABC100 LAT345 01/08/2022 10:30 11:30 ADL PER P2 ABC200 LAT456 01/08/2022 11:00 12:15 MEL SYD P4 ABC300 LAT567 01/08/2022 11:30 12:20 MEL ADL P5 ABC400 PASSENGERFLIGHTS Name FlightNo Jamie Roberts LAT123 Lily Chan LAT123 Duke Gold LAT456 Harry Nguyen LAT567 a) Write a stored procedure that receives a given date as input and prints the details of the aircraft/plane scheduled for flights on that date and separately prints those, which are not scheduled for a flight.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started