ITAP 3371 LAB1 FALL 2020 Instructions: Save this file as Lab1_YourlD_LabSection (replace Yourld with your ID and LabSection with your section. Upload your final solution to Blackboard, in the Lab 01 Assignment found in: Database II LAB_211 Course Course Assignments Content Area Lab 01 Content Folder Lab 01 Assignment In this lab, you are going to use the EMPLOYEE and DEPENDENT tables in the COMPANY database schema used in GEIT 3341 DB I. If you still have this schema, you are ready to do this lab, otherwise, run the scripts Company DDL and Company DML you will find in the Scrips folder. Log in to Oracle SQL Developer/Oracle Live SQL and answer the following questions. ITAP 3371 LAB1 FALL 2020 1) For the DEPENDENT table, write a query that uses simple CASE to display the following output assuming that spouses are entitled to a full ticket and other dependents (daughters and sons) are entitled to 75% of the ticket: (5 points) DEPENDENT_NAME RELATIONSHIP Annual Ticket Alice Theodor DAUGHTER SON SPOUSE Joy Abner Michael Alice Elizabeth 75% of Ticket 75% of Ticket Full Ticket Full Ticket 75% of Ticket 75% of Ticket SPOUSE SON DAUGHTER SPOUSE Full Ticket Insert here your query