A relational database system can relate data in one table to another, allowing a user to tie together data from several tables. Create a database called GTDB that consists of four tables, named EMPLOYEE. CLIENT. RESERVATION. FLIGHT. and CITY. Details of these tables are AIRPORT_CITY AIRPORT_COUNTRY 2. Identify and create the relationships between the tables. Enforce the integrity constraints. 3. Add data in the tables. - Minimum 5 records in the EMPLOYEE table. - Minimum 10 records in the CLINET table. - Minimum 15 records in the RESERVATION table. - Minimum 20 records in the FLIGHT table. - Minimum 30 records in the CITY table. One sample record for each table is shown below. You need to create your own data for each table. EMPLOYEE table record: EMP_ID EMP_FNAME EMP_LNAME EMP_ADDRESS EMP_CITY EMP_PHONE EMP_EMAIL E001 Peter Jones 1235th Street Vancouver 604-222-1234 pj@galaxy.ca CLIENT table record: CLINET_ID CLIENT_FNAME CLINET_LNAME CLIENT_GENDER CLINET_DOB CLINET_ADDRESS C00001 - Tim - Smith Male 1992-12-25 234 Nice Ave CLIENT_CITY CLINET_PHONE CLIENT_EMAIL New Westminster 604-222-2345 tim@gmail.com RESERVATION table record: RSERVATION_ID CLIENT_ID DEPARTURE_AIRPORT DESTINATION_AIRPORT DEPARTURE_DATE DEPARTURE_FLIGHT RETURN_DATE RETURN_FLIGHT BOOKING_REFERENCE TICKET_NUMBER AC11620230420AC127PKGKMY2345578896556 BOOKING_DATE PRICE EMP_ID 2023-01-15 527.99 E001 FLIGHT table record: FLIGHT_ID FLIGHT_NUMBER DEPARTURE_AIRPORT DEPARTURE_TIME ARRIVAL_AIRPORT F001 - AC116 - YVR - 1315 - YYZ AIRPORT table record: 4. Create a data input form for the CLIENT table and name it Client_YourFirstName_Form. Make any adjustments necessary to the form so that all data display properly. 5. Create a report named YourFirstName_Sales_Report grouped by employee id and booking date. The report should contain the following information in addition to proper headings, subtotals and totals. Employee Name, Booking Date, Booking Reference, Client Name, Price Submission: The following marking scheme will be used for this assignment: Tables, Relationships - Tables 5 tables - Relationships - Relationship Report - Complete and correct data entry - Client form with correct name - Sales Report Total 10 2 2 2 4 20 Submission: 1. Save as database file as GTDG_YourFirstName_FirstLastname_StudentId_A1.accdb 2. Submit in Blackboard before the due date