Create data dictionary for ERD diagram, create sql queries and create views

Oracle SQL developer database 1. Create a data dictionary that lists at least each of the tables, the columns, their domains and any other constraints that apply in word doc. 2. Create all the SQL query to create the tables in the ERD diagram 3. Create SQL query to insert the following transactions into the created tables in oracle sql developer database: Transaction 01: - The FBN001 route is from Perth to Singapore and has an estimated time of departure of 1100 and estimated time of arrival of 1600. On 20th June 2021, the airplane FH-FBT will be flying the route FBN001. It is a Boeing 767 with a capacity of 350 seats. Transaction 02: o Record the fact that FBN001 on 20th June 2021 will have the following crew:  Pilot: Martha McGee  Co-Pilot: Dorothy McDonald  Engineer: Albert Tharp  Head Steward: Kathy Kelly  Steward: Aubrey Ornellas Transaction 03: o Make a reservation for John Smith on Flight FBN001 on 20th June 2021. FBN001 flies from Perth to Singapore and has an estimated time of departure of 1100 and estimated time of arrival of 1600. He pays for his reservation with cash. Transaction 04: o Record that FBN001 on 20th June 2021 left Perth at 1105 and arrived in Singapore at 1555. Transaction 05: o On 21st June 2021, FH-FBT had a scheduled maintenance at the Melbourne Airport. The maintenance was supervised by Laurence Schreiner 4. Provide VIEWS for the following: ViewA:  All flight reservations made by John Smith including, for those flights that have flown, the duration of the flight ViewB:  Number of unreserved/available seats on FBN001 on 20th June 2021. ViewC:  Total hours flown EVER, for crew of the FBN001 on 20th June 2021. ViewD:  Total hours flown EVER, for the Pilot of the FBN001 on 20th June 2021, broken down by that person’s role (i.e., how many hours as pilot, how many as co-pilot etc?) ViewE:  Maintenance history for FH-FBT including the date and location of maintenance episode, whether or not the maintenance was scheduled or not, and the name and phone number of the supervising employee.