Visitors who want to conduct analyses on the financial data would download and form calculations using the data in their own software. HTML file B. PDF file C. EXCEL spreadsheet file D. WORD file

a. Write the SQL commands to create each table after normalization.b. Write insert command to add 5 rows in each of the table.c. Write a delete command to delete row from each table.d. Write the commands to query following values.1. Show Product id and finish date for all Products2. Show Product id and finish for all Products, sort by Product_Line_ID byascending order3. Show Product id and finish for all Products, sort by Product_Line_ID bydescending order4. Show each Product_Line_ID and the total number of Products for theProduct_Line_ID

Please use following table information to answer the exercises.SQL> DESC DEPARTMENTSName Null? Type----------------------------------------- -------- ----------------------------DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4)     SQL> DESC EMPLOYEESName Null? Type----------------------------------------- -------- ----------------------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4) 12. Display the last name, hire date, and day of the week on which the employee started. Label the columnDAY. Order the results by the week starting with Monday.

Please help with the follwoing: No staff member may have a salary that exceeds $100,000.00 This is an example of: Select one: a. NULL Constraint  b. None of the mentioned c. UNIQUE Constraint d. CHECK  Constraint

Produce a script file with 15 queries: At least two using join At least three using where clause At least three using order by At least two using single-row functions At least two using group by and group functions at least one nested query At least 4 queries from chapter 1 - 6 (exclude Create Table, Insert queries) ------- TABLE 1 create TABLE ProCoaches(pro_co_ID INTEGER PRIMARY KEY,pro_coachName Varchar(50) NOT NULL,pro_coachLocation Varchar(20)); INSERT INTO ProCoaches VALUES (1, 'John', 'Missoula'); INSERT INTO ProCoaches VALUES (2, 'Joe', 'Bozeman');INSERT INTO ProCoaches VALUES (3, 'Tara','Butte'); select * FROM ProCoaches;select LENGTH('Missoula') AS LengthOfLocation;select pro_coachName FROM ProCoaches where pro_coachLocation='Missoula'; select COUNT(pro_co_ID), pro_coachLocation FROM ProCoaches GROUP BY pro_coachLocation; TABLE 2 create TABLE ProCyclist(pro_cy_ID VARCHAR(10) PRIMARY KEY,pro_cyclist_Name VARCHAR(50) NOT NULL,pro_cyclist_Gender Varchar(20),pro_cyclist_DOB…