Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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 rospectively. 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, DA EEENRED FI.IAHTS a) Write a stored procedure that receives a given date as input and prints the details of the aircraft/plane seheduled for flights on that date and separately prints thoso, which aro not scheduled for a flight. [20 marka] b) A trigger on the FLIGHT table that prevents a plane from being assigned for a flight whose service is due within the next 3 months from the flight date. [15 marks]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What is paper chromatography?

Answered: 1 week ago

Question

Explain the cost of capital.

Answered: 1 week ago

Question

Define capital structure.

Answered: 1 week ago