The following additional integrity constraints MUST be implemented: 1. When a pilot leaves the airport, data about the pilot are removed from the database, but the data about flights implemented by the pilot must remain in the database. 2. The attribute Licence (Pilot entity set) must accept only distinct values. 3. The domain for attribute Score (Passes relationship set) comprises integer numbers between 0 and 100 . 4. The domain for attribute Capacity (Hangar entity set) is integer numbers greater than 0 and less or equal than 3 . SUBMIT: 1. Cover page indicating your last name, first name, student number, course code and section. 2. Printout of your recorded final session in Oracle 11g on SIT Teaching Server. The printout must demonstrate the execution all your SQL statements from the file. 3. Please make sure that all SQL statements are shown on the printout (spool file). 4. I reserve the right to ask you questions about the submitted SQL statements. If you submit SQL statements you cannot explain, you WILL receive zero. 5. Tables created MUST be kept in your Oracle account until your assignment will be graded. If you submit the assignment, but tables do not exist in our database on School oITEC Teaching Server, your mark will be 0 . You will be informed when you may drop the tables. GENERAL INSTRUCTIONS - ERD is implemented using Chen notation. - Assume that the names and phone numbers are atomic - Each capital letter (like M, N, etc.) means "many". - Assign reasonable data types for table attributes (fields). - DO NOT use binders, folders, paper clips etc. Have the sheets stapled together