Consider the following relations for a simple airport database $($primary keys are in bold and underline$).$

Hangars $($hangNo capacity, location, status$)$

AirplaneTypes $($Model$,$ capacity, weight$)$

Airplanes $($regNo$,$ model, hangNO$)$

Owners $($owner name, address, phone, ssn$)$

Owns $($regNo$,$ ownID startedDate$)$

There are four foreign keys for this database:

the attribute hangNo of the relation Airplanes that references the relation Hangars,

the attribute model of the relation Airplanes that references the relation AirplaneTypes,

the attribute regNo of the relation Owns that references the relation Airplanes, and

the attribute ownID of the relation Owns that references the relation Owner.

Q$1$: Write SQL statements to define the above relation Hangars. You should choose a suitable data type and $/$ or data size for each column and be sure to declare appropriate integrity constraint$($s$).$

Q$2.$ Which of the following SQL statement is used to define the above relation Airplanes? Ensure that the data type and size for each attribute are appropriate and integrity constraint$($s$)$ are declared. $($Enter A$,$ B$,$ C$,$ or D$)$