An airline company is interested in implementing a database system to manipulate the flights that it organizes. The airline company has a certain number of airplanes. Each airplane has a unique code, a number of seats and a production year. An airplane belongs to a certain airplane model. Each model has a unique model number and is provided by a certain company. We have different airplanes of each model. Each flight is identified by a flight number, a scheduled departure time and a scheduled arrival time. We want also to keep track of the airport from which the flight is scheduled as well as the destination airport. Each airport is identified by a unique code, its name and the country in which it is located. Journeys of each flight are organized on a daily basis. Each journey is identified by a date, its actual departure time, its actual arrival time, and the number of passengers, in addition to the airplane that performs the journey. We want to keep track of the seats occupied, where each seat is identified by a seat number, a passenger name, nationality, age and phone number.

Steps to be done:

- Step 1: Collecting requirements and analysis, - Step 2: Data Modeling (ER diagram) - Step 3: Mapping the ER diagram into a relational model. - Step 4: Put the tables which you have mapped in the 3rd normal form - Step 5: Create the tables and fill them with few records - Step 6: Data Manipulation (Queries in the relational algebra + SQL)

Please solve all steps