Q$1.$ Consider the following flight database.

The flight database stores details about an airline's flights and seat bookings.

Consider the following requirements list:

An airline has one or more airplanes and each airplane belongs to exactly one airline.

An airline has a name and is identified by a unique code.

An airplane has a model number, a unique registration number, and the capacity to take one

or more passengers.

A flight has a unique flight number, a departure airport, a destination airport, a departure date

and time, and an arrival date and time.

Each flight is carried out by a single airplane and each airplane may fly many flights. A new

airplane may not fly any flight at all.

A passenger has a given name, a surname, and a unique email address.

A passenger can book a seat on a flight with the seat number recorded in booking.

A passenger can book any number of flights while a flight can be booked by any number of

passengers. A flight must carry at least one passenger and each passenger must book at least

one flight.

$($a$)$ Draw an entity$-$relationship diagram that describes the above business environment. Underline

the primary key in each entity. You don't need to include foreign key$($s$)$ in the entity. For many$-$

to$-$many relationship, you should convert it into two one$-$to$-$many relationships. If there is

anything that the question does not specify clearly, you may write down your assumption.

$(15$ marks$)$

$($b$)$ Copy the following table to your answer booklet for comparing the differences between data

warehouse and data mart.

$(5$ marks$)$