Consider the following relations for a simple airport databas 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: 1. The attribute hangNo of the relation Airplanes that references the relation Hangars, 2. The attribute model of the relation Airplanes that references the relation AirplaneTypes, 3. The attribute regNo of the relation Owns that references the relation Airplanes, and 4. The attribute ownID of the relation Owns that references the relation Owner. Q1: Write SQL statements to define the above relation Hangars. You should choose a suitable data type and/or daya size for each column and be sure to declare appropriate integrity constraint(s). Q2. Which of the following SQL statements is used to define the above relation Airplanes? Ensure the data type and size for each attribute are appropriate and integrity constraint(s) are declared. A. CREATE TABLE Airplanes ( regNo VARCHAR(5), model VARCHAR(6), hangNo CHAR(5), FOREIGN KEY( model ) REFERENCES AirplaneTypes)Model, FOREIGN KEY( hangNo ) REFERENCES Hangars (hangNo)); B. CREATE TABLE Airplanes ( regNo VARCHAR(5), model CHAR(6), hangNo CHAR(5), UNIQUE KEY(regNo), FOREIGN KEY( model ) REFERENCES AirplaneTypes(model), FOREIGN KEY( hang no ) references Hangars (handNo)); C. CREATE TABLE Airplanes ( regNo VARCHAR(5), model CHAR(6), hangNo CHAR(5), PRIMARY KEY(regNo), FOREIGN KEY( model ) REFERENCES AirplaneTypes(model), FOREIGN KEY( hangNo ) REFERENCES Hangars (hangNo)); D. CREATE TABLE Airplanes ( regNo VARCHAR(5), model VARCHAR(6), hangNo CHAR(5), PRIMARY KEY(regNo)); Q3. Which of the following SQL statements is used to define the above relation Owns? Make sure that the data type and size for each attribute are appropriate and integrity constraint(s) are declared. Assume that no referential integrity constraints violations. A. CREATE TABLE Owns ( regNo VARCHAR(5), ownID CHAR(7), startedDate DATE, PRIMARY KEY(regNo), PRIMARY KEY(ownID), FOREIGN KEY( regNo) REFERENCES Airplanes(regNo), FOREIGN KEY( ownID) REFERENCES Owners (ownID)); B. CREATE TABLE Owns ( regNo VARCHAR(5), ownID CHAR(7), startedDate INT, UNIQUE KEY(regNo, ownID)); C. CREATE TABLE Owns ( regNo VARCHAR(5), ownID CHAR(7), startedDate DATE, PRIMARY KEY(regNo, ownID), FOREIGN KEY( regNo) REFERENCES Airplanes(regNo), FOREIGN KEY(ownID) REFRRENCES Owners (ownID)); D. CREATE TABLE Owns ( regNo VARCHAR(5), ownID CHAR(7), startedDate DATE, PROMARY KEY(regNo, ownID)); RENCES Branches (branchName));