1. The current departure times for all destinations are delayed by 30 minutes.

2. List all flight numbers, departure times and arrival times and aircraft names

for the destination Kuala Lumpur - Pulau Langkawi on 19 October 2016.

3. List the applicable aircraft ID to fly from Labuan to Pulau Langkawi without

stop (hint: flyin gRange > flightDistance).

4. (iv) List the names of all pilots certified for Airbus aircrafts in alphabetical order.

5. (v) List all flight numbers which depart from city names that begins with

"Kuala" and arrive in city names which do not end with "Bharu"

6. Name the pilot (s) who has/have not certified to fly Boeing aircrafts.

INSTRUCTIONS: 1. This task should be done individually. 2. You need to submit the hard copy of this task by the end of the class. 3. Any plagiarism and late submission will be penalized. LEARNING OUTCOME: Upon the completion of this lab session, students will have the ability to perform the basic structure of SQL and how it is implemented as data manipulation language. QUESTION: Figure 1 shows a part of database content held in Asia Airlines based on the following relations: Employee (EHP ID, EMP Name, EMP Base Salary, EMP position) Aircraft (AIRCRAFT ID, A_Name, A Model, AFlying Range) Charter (CHARTER ID, FLIGHT-NUM, C_DATE, C From, C_To, CDistanceKM, C_Depart_Time, C_Arrive_Time. AIRCRAFT ID) Certified (EHP ID, AIRCRAFT ID, Certified Date) where o Employee contains details of all employees (pilots and non-pilots); o Aircraft contains details of aircraft; o Charter contains details of the flights; and o Certified contains details of the staff who are certified to fly an aircraft. Formulate the following queries in Structured Query Language (SQL). Provide explanation/proof of work for each of your