Question: 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

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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

can you please help me to find the code ? hint : Company DDL create table DEPARTMENT ( DNAME VARCHAR(30), DNUMBER NUMBER(4) PRIMARY KEY, MGR_SSN CHAR(9), MGR_START_DATE DATE); create table EMPLOYEE (...

1) Use the CREATE TABLE command to create the following table and call it Lab3EmpTable (the bold and underlined attribute refers to the primary key): Column Name ID Fname Lname Title Salary$ Data...

Create an Abstract Data Type (ADT) called DOB_ADT with the fields D, M, and Y all of type INTEGER to store the birth date day, month, and year respectively. Also, include a function called age with a...

ASSESSMENT/MIDTERM 1 ITAP EVIDENCE FALL 2020 In Pennsylvania, the following is a crime: No person other than a medical doctor shall engage in any of the following conduct except as authorized or...

The questions are at the bottom. Please use the attached courier pages to answer the questions. TOP Round 3 Dec. 31 2026 COMP-XM Riya Report INQUIRER Singh Andrews Baldwin Chester Riya Singh Digby...

The annual report for Fraser & Neave Holdings Bhd is as follows: The annual report for Dutch Lady Milk Industry Bhd is as follows: Fraser & Neave Holdings Bhd and Dutch Lady Milk Industries Berhad...

Math\t107-6381\t-\tQuiz\t#4\t-\tSchultz\t-\tDue\tFebruary\t21,\t2016\t-\tpage\t1\tof 3 Follow\tthese\tdirections\tcarefully. This\tquiz\tis\tdue\tby\t11:59\tEastern\ttime\ton\tFebruary\t21,\t2016. o...

The following transactions were completed by The Spencer Gallery during the current fiscal year ended December 31: Mar. 15. Reinstated the account of Brad Atwell, which had been written off in the...

The amount of time (in seconds) needed to complete a critical task on an assembly line was measured for a sample of 50 assemblies. These data are as follows: a. Draw a stem-and-leaf display. b. Draw...

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting 2010 housing starts using the 2008 and 2009 data in the Excel file Housing Starts. Month...

If you receive $ 1 0 , 0 0 0 payment at the end each year for the next 1 2 years, what type of cash flow do you have? Group of answer choices Uneven cash flow stream An annuity Perpetuity An annuity...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3 Identify six potential sources and causes of risk in global supply chains. Use the reference to Peck (2003) below to propose counter measures.

1 Why is time important to competitive advantage? Identify and explain six key contributions that speed can make to logistics strategy.

2 What are the potential negatives of WDTs new JIT system in terms of limiting customer choice and short-circuiting the design process? Sid Beckett, the Managing Director of Wiltshire Distribution...