Design a database for an airline reservation system.

The requirements for the system are:

$$ Each airport has a unique code $($e$.$g$.,$ LAX$),$ name $($e$.$g$.,$ Los Angeles International

Airport$),$ state and city where it is located.

$$ Each $$ight has a unique number $($e$.$g$.,$ AA$28),$ airline identier $($e$.$g$.,$ American

Airlines$),$ and the weekdays on which the $$ight is scheduled $($e$.$g$.,$ for every day of

the week except Sunday$).$

$$ A $$ight is composed of one or more $$ight legs. For example, $$ight number AA$28$

from Los Angeles to New York may have two $$ight legs: leg $1$ from Los Angeles to

Houston and leg $2$ from Houston to New York.

$$ Each $$ight leg has a departure airport, scheduled departure time, arrival airport

and a scheduled arrival time.

$1$