Answer Happy

PART A (10 MARKS) As a database designer, you need to develop a flight database system based on the following requirements: 1. Open Microsoft Access and create a blank Access database. Save as: "YourFullName_StudentID_Flight Database System" ANSWER: Paste your screenshot of database here 2. Create tables as listed below and choose appropriate data types for each attribute. Then create the relationship between tables. You also need to insert 3 records (sample data) per table. PILOT (PilotID, P_FName, P_LName, PhoneNum, Designation, FlightID*) FLIGHT (FlightID, DepartDate, DepartTime, ArrivalDate, ArrivalTime, DestinationFrom, Destination To, AirplaneID*) BOARDING_PASS (BoardingPassID, Gate, Class, FlightID*, PassengerID*) PASSENGER (PassengerID, FName, LName, Gender, Country, Contact Num) AIRPLANE (AirplaneID, Model, Manufacturer) CABIN_CREW (Cabin CrewID, C_FName, C_LName, PhoneNum, FlightID*) *Data for Designation in table PILOT is either Captain or Co-Pilot. *For each flight, there are always at least two pilots and many cabin crew. *Data for Class in table BOARDING_PASS is First, Business or Economy. (1 mark) ANSWER: Paste your screenshot of tables, relationships and records here ANSWER: Paste your screenshot of SQL and output here (14 marks) PART B (30 MARKS) Based on tables you created in Part A, write SQL statements (screenshot your SQL queries and output) for the following questions: 1. Insert your own details into table PASSENGER. (3 marks)