Please answer correctly and straightforwardly, and I will give you a thumbs up. please do not copy the old answers. thank you

AIRPORT \begin{tabular}{|l|l|l|l|} \hline Airport_code & Name & City & State \\ \hline \end{tabular} FLIGHT \begin{tabular}{|l|l|l|} \hline Flight_number & Airline & Weekdays \\ \hline \end{tabular} FLIGHT_LEG \begin{tabular}{|l|c|c|c} \hline Flight_number & Leg_number & Departure_airport_code & Scheduled_departure_time \\ \hline & Arrival_airport_code & Scheduled_arrival_time \\ \hline \end{tabular} LEG_INSTANCE \begin{tabular}{|c|c|c|c|c|c|c|} \hline Flight_number & Leg_number & Date & Number_of_available_seats & Airplane_id \\ \hline \hline Departure_airport_code & Departure_time & Arrival_airport_code & Arrival_time \\ \hline \end{tabular} FARE \begin{tabular}{|l|l|l|l|} \hline Flight_number & Fare_code & Amount & Restrictions \\ \hline \end{tabular} AIRPLANE_TYPE \begin{tabular}{|l|l|l|} \hline Airplane_type_name & Max_seats & Company \\ \hline \end{tabular} CAN_LAND \begin{tabular}{|l|l|} \hline Airplane_type_name & Airport_code \\ \hline \end{tabular} AIRPLANE \begin{tabular}{|l|l|l|} \hline Airplane_id & Total_number_of_seats & Airplane_type \\ \hline \end{tabular} SEAT_RESERVATION \begin{tabular}{|l|l|l|l|l|l|} \hline Flight_number & Leg_number & Date & Seat_number & Customer_name & Customer_phone \\ \hline \end{tabular} e) Write the DDL queries to create the AIRLINE database, the tables in it, and all key and referential integrity constraints. You must have appropriate data types for each attribute of the relations. Except for the query to create the database (which is not compulsory to include in your solution), all your queries must be executable in a single click. Your DDL commands must also use at least one of the following types of constraint where appropriate: i. Check constraint ii. Domain constraint i.e., use a defined/created domain If you make any assumptions regarding a data type or domain of an attribute, you must state the assumption in the comment before the creation of each relation. f) Write the DDL queries to modify the necessary table(s) so that if a flight number is removed or updated, all associated flight leg and flight leg instance are also be removed or updated, respectively