View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file forms. The following are sample employee information forms: EMP_ID 7839   EMP_ID 7654     EMP_NAME JOHN CHIU   EMP_NAME ANDRE MARTIN     SOC_INS 123-234-345   SOC_INS 678-345-123     POSITION MANAGER   POSITION SALES     SUPERVISOR     SUPERVISOR JOHN CHIU     HIREDATE November 13, 1999   HIREDATE September 24, 1999     EMP_ID 7434   EMP_ID 7435     EMP_NAME PARVEZ RAI   EMP_NAME DANIEL CHOY     SOC_INS 234-123-432   SOC_INS 345-312-234     POSITION SALES   POSITION CLERK     SUPERVISOR JOHN CHIU   SUPERVISOR       HIREDATE June 24, 1980   HIREDATE August 4, 1998     Business Rules: 1. SOC_INS must always be different for each employee. 2. EMP_NAME must always have a value. Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF and explain or list the primary key and foreign

Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created on November 15, 2021. Task 13: List the invoice number and invoice date for each invoice created for the customer James Gonzalez. Task 15: List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25lb).   TEMPLATE -- Task # 6SELECT CUSTOMER.CUST_ID, FIRST_NAME, LAST_NAMEFROM _____________, _________________WHERE CUSTOMER.________________ = ______________.CUST_IDAND INVOICES.____________________ <> '2021-11-15'; -- Task # 13SELECT INVOICE_NUM, INVOICE_DATEFROM ______________WHERE ____________ IN (SELECT CUST_ID FROM CUSTOMER WHERE _____________ = _______________AND ____________ = ______________); -- Task # 15SELECT DISTINCT INVOICES.INVOICE_NUM, INVOICES.INVOICE_DATEFROM INVOICES, INVOICE_LINE, ITEM, CUSTOMERWHERE INVOICES.INVOICE_NUM = INVOICE_LINE.INVOICE_NUMAND INVOICE_LINE.ITEM_ID =…

Task 15: List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25lb). Task 16: List the invoice number and invoice date for each invoice that was created for James Gonzalez and that contains an invoice line for Wild Bird Food (25lb).

View 4 Seneca Courses Inc. Customer Forms All customer information for SCI is maintained on file forms. The following are sample customer information forms:     CUST_ID 78   CUST _ID 54     NAME YORK UNIVERSITY   NAME SENECA COLLEGE     LOCATION NORTH YORK   LOCATION NORTH YORK     SALES_REP ANDRE MARTIN   SALES_REP PARVEZ RAI             CUST _ID 74   CUST _ID 43     NAME RYERSON   NAME INDIGO BOOKS     LOCATION TORONTO   LOCATION TORONTO     SALES_REP PARVEZ RAI   SALES_REP ANDRE MARTIN     Business Rules: NAME must always be different for each customer.   SALES_REP must always have a value. SALES_REP must be an existing employee. A customer only has one sales rep, but the sales_rep may have more than one customer.   Normalize the above user view.  Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF and explain or list the…