Can you please help me with database question:

Based on the description in question a, Draw the dependency diagram of Flight -reservation-system system highlighting Partial Dependency, Transitive Dependency, and Full Dependency in 1NF (also highlighted in yellow)

4. Proceed with formal normalization form to show all required steps to normalize the following Flight Ticket Reservation System. a) A given passenger might book flight from different air-line companies. The system will register all flights for all airliners, their available seats of different service classes (business, economy class) along with their corresponding prices. Then, passenger should be able to get a bill for her flight reservation showing her the price and seat number We call the Unnormalized table as FLIGHTRESERVATION Enumerate all Business Rules of FLIGHTRESERVATION . .What is the type of Relationship between passenger and flight entity sets? . Edit the instance of data of the Unnormalized table FLIGHTRESERVATION using data of yours. . Notice and determine the composite primary key (candidate key) of FLIGHTRESERVATION table. Draw the dependency diagram of FLIGHTRESERVATION system highlighting Partial Dependency, Transitive Dependency, and Full Dependency in INF Define the corresponding tables in 2NF. Define the corresponding tables in 3NF. Draw the entity relationship E-R Diagram of the above system. . 4. Proceed with formal normalization form to show all required steps to normalize the following Flight Ticket Reservation System. a) A given passenger might book flight from different air-line companies. The system will register all flights for all airliners, their available seats of different service classes (business, economy class) along with their corresponding prices. Then, passenger should be able to get a bill for her flight reservation showing her the price and seat number We call the Unnormalized table as FLIGHTRESERVATION Enumerate all Business Rules of FLIGHTRESERVATION . .What is the type of Relationship between passenger and flight entity sets? . Edit the instance of data of the Unnormalized table FLIGHTRESERVATION using data of yours. . Notice and determine the composite primary key (candidate key) of FLIGHTRESERVATION table. Draw the dependency diagram of FLIGHTRESERVATION system highlighting Partial Dependency, Transitive Dependency, and Full Dependency in INF Define the corresponding tables in 2NF. Define the corresponding tables in 3NF. Draw the entity relationship E-R Diagram of the above system