This is a database related question

| e | | a Search 7 of 10 1 FIGURE P3.24 THE CH03AVIACO DATABASE TABLES (CONTINUED) - Table name: PILOT Database name: Ch03 AviaCo EMP NUM PL LICENSE 101 ATP 04 ATP 105 COM 106 COM 109 COM PL RATINGSPL MED TYPE PL. MED DATE PL PT135 DATE 11-Jan-16 17-Jan-16 02-Jan-16 02-Feb-16 15-Jan-16 ATPISELMELInstrICFI ATPISELMELAnstr 20-Jan-16 18-Dec-15 05-Jan-16 10-Dec-15 22-Jan-16 OMMISELMELInstr ATPISELMELISESAnstrICFI1 The pilot licenses shown in the PILOT table include ATP = Airline Transport Pilot and COMM = Commercial Pilot. Businesses that operate on-demand air services are governed by Part 135 of the Federal Air Regulations (FARs), which are enforced by the Federal Aviation Administration (FAA). Such businesses are known as "Part 135 operators." Part 135 operations require that pilots successfully complete flight proficiency checks every six months. The "Part 135" flight proficiency check date is recorded in PIL PT135 DATE. To fly commercially, pilots must have at least a commercial license and a second-class medical certificate (PIL MED TYPE 2) The PIL RATINGS include: SEL Single Engine, Land SES Single Engine, Sea CFI = Certified Flight Instructor MEL Instr. Multiengine, Land Instrument CFII Certified Flight Instructor, Instrument Table name: EMPLOYEE EMP NUMEMP TILE EMP LNAME EMP FNAME EMP INITIAL LEMP 00B EMP HRE DATE 15-Jun-42 19-Mar-85 100 Mr 101 Ms 102 M IU Ms 104 M Kotmycz Geor Rhond Lange