NOTE: No built$-$in ORACLE column numbering $($such as ROWNUM, TOP, FETCH, etc.$)$ or

other ORACLE ranking facilities $($such as RANK$)$ can be used in this assignment.

Implement the following tasks using ORACLE Application Express $($APEX$).$

Download the file NEASchema.sql from the LMS site and run it on APEX. This file contains all

the CREATE and INSERT statements you will need for this assignment. Run the schema file on

APEX following the same process we followed to run a schema during the lectures and labs.

NOTE: YOU DO NOT NEED TO INSERT MORE DATA INTO THE TABLES.

CSE$2/4$DBF$-$Assignment $2-$S$1-2024$ Page $2$ of $4$

The list of tables available for this assignment is the following:

MODEL$($modelID$,$ economySeats, buisnessSeats, firstClassSeats,

cargoCapacity, fuelCapacity, length, wingspan$)$

LOCATION$($airportCode$,$ country, address, phone$)$

TICKET$($ticketNum$,$ luggageLimit, seatNum, classCode,

medicalCondition, mealChoice, customerID, flightID$)$

ROUTE$($routeID$,$ description, arriveAirportCode, departAirportCode$)$

AIRCRAFT$($aircraftID$,$ modelID$)$

STAFF$($staffID$,$ name, address, email, phone, passportNum$)$

PILOT $($staffID$,$ prvHrsPilotExp$)$

FLIGHTATTENDANT $($staffID$)$

CUSTOMER$($customerID$,$ name, address, country, email, phone,

birthdate, passportNum$)$

FLIGHT$($flightID$,$ estDepartureDateTime, actDepartDateTime,

actArriveDateTime, avgSpeed, avgHeight, estDuration, estFuel,

captainStaffID, firstOfficerStaffID, routeID, aircraftID$)$

ADDITIONAL$\_$PILOT$($staffID$,$ flightID, activityCode, activityDesc$)$

HOSTING$($staffID$,$ flightID$)$

PILOT$\_$QUALIFICATION$($qualification$,$ staffID$)$

NOTE: PK is printed underlined, and FK is written in italics.