Jet Airline is an international airline company who is looking to develop an effective RDBMS to cater for their growing business needs. As a junior developer, you have been asked to develop a database for New Jet Airline which will satisfy all their requirements. The database should contain information about passengers, flights, departure, employees of the airline and aircrafts.• For passengers- name, address, phone number and related information to store.• For employees- the company wants to record the name, address, salary, identification number and flight information. Not all employees can fly aircrafts, just the pilots. For all these employees, it is required to record the qualification i.e. what kind of plane they can fly.• For planes- it is required to record the model and manufacturers of the plane. The airline has many aircrafts of certain type.• For flights- the airline needs to keep the information, such as flight number, origin, destination, departure time and arrival time. For the same source-destination, there can be many flights per week.Relevant assumptions (if required) can be made. Database should be able to get the following information from the developed database:1. Statistics of the payments, passengers, flights and employees2. Number of bookings and cancellations for a specific day for specific journey3. Number of flights for specific journey in a week.4. Average number of passengers for specific source – destination
