SQLFINAL.LOCATIONSFINAL.COUNTRIESP LOCATION_IDNUMBERVARCHAR2 (40 BYTE)FINAL.REGIONSP. COUNTRY_IDCOUNTRY_NAMEREGION_IDCREATED_BYCREATED DATEMODIFIED_BYMODIFIED_DATECHAR (2 BYTE)VARCHAR2 (40 BYTE)* REGION_IDREGION_NAMECREATED_BYSTREET ADDRESSNUMBER* CITYVARCHAR2 (30 BYTE)VARCHAR2 (25 BYTE)NUMBERVARCHAR2 (25 BYTE)VARCHAR2 (20 BYTE)CHAR (2 BYTE)VARCHAR2 (30 BYTE)STATE_PROVINCEVARCHAR2 (30 BYTE)VARCHAR2 (30 BYTE)POSTAL_CODECOUNTRY_IDCREATED_BYCREATED DATEDATEDATEMODIFIED_BYMODIFIED_DATEVARCHAR2 (30 BYTE)VARCHAR2 (30 BYTE)DATEDATECREATED_DATEMODIFIED_BYMODIFIED_DATEDATEREGION_PK (REGION_ID)O REGION_PK (REOION_ID)VARCHAR2 (00 BYTE)COUNTRIES_PK (COUNTRY_ID)DATEs COUNTRIES FK1 (REGION_ID)LOCATIONS_PK(LOCATION_ID)o COUNTRIES_PK (COUNTRY_ID)LOCATIONS_FK1 (COUNTRY_ID)• LOCATIONS_PK (LOCATION_ID)FINAL.EMPLOYEESFINAL. EMP DETAILS_VIEWP'EMPLOYEE_IDFIRST NAMELAST_NAMEFINAL.DEPARTMENTSNUMBERC1ROWIDVARCHAR2 (20 BYTE)P' DEPARTMENT_ID* DEPARTMENT_NAMENUMBER (4)C2ROWIDVARCHAR2 (25 BYTE)VARCHAR2 (30 BYTE)NUMBERc3ROWIDEMAILVARCHAR2 (25 BYTE)VARCHAR2 (20 BYTE)VARCHAR2 (30 BYTE)MANAGER_IDC4ROWIDPHONE NUMBERFLOCATION_IDNUMBERC5ROWIDCREATED_BYCREATED DATECREATED_BYVARCHAR2 (30 BYTE)ceROWIDDATECREATED DATEMODIFIED_BYMODIFIED_DATEDATEROWIDVARCHAR2 (40 BYTE)NUMBER (4)C7MODIFIED_BYVARCHAR2 (30 BYTE)DATEVARCHAR2 (30 BYTE)COUNTRY_NAME* DEPARTMENT ID* DEPARTMENT NAME* EMPLOYEE_IDFIRST_NAMELAST_NAMEDATEMODIFIED_DATEP EMPLOYEES_PK (EMPLOYEE_ID)O EMPLOYEES_PK (EMPLOYEE_ID)VARCHAR2 (30 BYTE)> DEPARTMENTS_PK (DEPARTMENT_ID)NUMBERDEPARTMENTS_FK1 (LOCATION_ID)VARCHAR2 (20 BYTE)O DEPARTMENTS PK (DEPARTMENT_ID)VARCHAR2 (25 BYTE)NUMBER (2,2)VARCHAR2 (35 BYTE)NUMBERNUMBERNUMBER (0,2)COMMISSION_PCT* JOB_TITLEJOB_IDMANAGER_IDSALARYFINAL. JOB HISTORY* CITYVARCHAR2 (30 BYTE)CHAR (2 BYTE)PF EMPLOYEE_IDP START DATEEND DATEF' JOB_IDFNUMBERCOUNTRY_ID* LOCATION_IDSTATE_PROVINCEREGION_NAMEDATENUMBERDATEVARCHAR2 (25 BYTE)VARCHAR2 (26 BYTE)NUMBERFINAL.JOBSDEPARTMENT_IDNUMBER (4)P JOB_ID* JOB_TITLEMIN_SALARYMAX_SALARYCOMMISSION_PCTCREATED BYCREATED_DATEMODIFIED_BYMODIFIED_DATENUMBERSALARYNUMBER (0.2)VARCHAR2 (35 BYTE)FMANAGER_ IDCREATED_BYCREATED DATEMODIFIED_BYMODIFIED_DATENUMBERNUMBER (0)VARCHAR2 (30 BYTE)DATENUMBER (0)NUMBER 22)VARCHAR2 (30 BYTE)DATEVARCHAR2 (20 BYTE)DATEJOB_HISTORY_PK (EMPLOYEE_ID. START_DATE)VARCHAR2 (30 BYTE)DATEJOB_HISTORY FKI (DEPARTMENT_ID)SJOB_HISTORY_FK2 (EMPLOYEE_ID)SJOB_HISTORY_FK3 (MANAGER_ID)JOB_HISTORY_FK4 (JOB_ID)lo JOB_HISTORY_PK (EMPLOYEE_ID, START DATE)> JOBS_PK (JOB_ID)O JOBS_PK (JOB_ID)Build the schema and one view, Build a sequencefor each of these tables, sequence is valued usingan insert trigger

Below we use for the database scripts 1) CREATE TABLE ==> here we use the constraint scripts to…

FINAL.LOCATONS FINAL.COUNTRIES FINAL.REGIONS P LOCATION_ID STREET ADORESS * CITY NUMBER * COUNTRY_ID COUNTRY_NAME REGION_ID CREATED_BY CREATED_DATE MODIFIED_BY MODIFIED_DATE VARCHAR2 (40 BYTE) VARCHAR2 00 BYTE) CHAR 2 BYTE) VARCHAR2 (40 BYTE) NUMBER REGION_ID NUMBER REGION_NAME CREATED_BY CREATED_DATE MODIFIED_BY MODIFIED_DATE VARCHAR2 (25 BYTE) STATE_PROVINCE VARCHAR2 25 BYTE) VARCHAR2 00 BYTE) DATE VARCHAR2 (30 BYTE) POSTAL_CODE COUNTRY_ID CREATED_BY CREATED_DATE MODIFIED_BY MODIFIED DATE VARCHAR2 20 BYTE) DATE CHAR 2 BYTE) VARCHAR2 (30 BYTE) VARCHAR2 (30 BYTE) DATE VARCHAR2 (30 BYTE) DATE DATE REGION_PK (REGION_ID) VARCHAR2 (30 BYTE) > COUNTRIES_PK (COUNTRY_ID) DATE O REGION_PK (REGION_ID) COUNTRIES_FK1 (REGION_ID) > LOCATIONS_PK (LOCATION_ID) LOCATIONS FK1 (COUNTRY_ID) O LOCATIONS PK (LOCATION_ID) O COUNTRIES_PK (COUNTRY_ID) FINAL EMPLOYEES FINAL EMP DETAILS VIEW FINAL.DEPARTMENTS P EMPLOYEE_ID NUMBER C1 ROWID FIRST NAME VARCHAR2 20 BYTE) PDEPARTMENT_ID * DEPARTMENT NAME NUMBER (4) C2 ROWID LAST_NAME VARCHAR2 (25 BYTE) VARCHAR2 25 BYTE) VARCHAR2 (30 BYTE) ca ROWID EMAIL MANAGER_ID NUMBER C4 ROWID PHONE NUMBER VARCHAR2 20 BYTE) VARCHAR2 (30 BYTE) LOCATION_ID NUMBER VARCHAR2 (30 BYTE) ROWID CREATED_BY CREATED_BY ce ROWID CREATED DATE DATE CREATED_DATE MODIFIED_BY MODIFIED_DATE C7 COUNTRY NAME * DEPARTMENT I0 DEPARTMENT_NAME * EMPLOYEE_ID FIRST NAME LAST NAME DATE ROWID VARCHAR2 30 BYTE) MODIFIED_BY MODIFIED DATE VARCHAR2 30 BYTE) VARCHAR2 (40 BYTE) DATE DATE NUMBER (4) VARCHAR2 00 BYTE) > DEPARTMENTS_PK (DEPARTMENT_ID) EMPLOYEES_PK (EMPLOYEE_ID) NUMBER O EMPLOYEES_PK (EMPLOYEE_ID) DEPARTMENTS_FK1 (LOCATION_ID) VARCHAR2 20 BYTE) VARCHAR2 25 BYTE) O DEPARTMENTS_PK (DEPARTMENT_ID) COMMISSION_PCT NUMBER (2.2) * JOB_TITLE VARCHAR2 05 BYTE) NUMBER aisor. MANAGER_ID NUMBER NUMBER 9.2) VARCHAR2 (30 BYTE) SALARY * CITY COUNTRY_ID * LOCATION_ID FINAL. JOB_HISTORY PF EMPLOYEE_ID P START DATE END DATE F JOB_ID DEPARTMENT ID SALARY MANAGER_ID CREATED_BY CREATED_DATE MODIFIED_BY MODIFIED DATE NUMBER CHAR 2 BYTE) NUMBER VARCHAR2 25 BYTE) DATE DATE STATE_PROVINCE NUMBER FINAL.JOBS REGION_NAME VARCHAR2 (25 BYTE) NUMBER (4) JOB_ID arsor * JOB_TITLE MIN_SALARY MAX_SALARY COMMISSION_PCT CREATED_BY CREATED_DATE NUMBER NUMBER (9.2) VARCHAR2 (35 BYTE) NUMBER NUMBER (0) VARCHAR2 30 BYTE) NUMBER (0) DATE NUMBER 22) VARCHAR2 (30 BYTE) VARCHAR2 (30 BYTE) DATE DATE >JOB_HISTORY_PK (EMPLOYEE_ID. START_DATE) JOB_HISTORY_FK1 (DEPARTMENT_ID) SJOB_HISTORY FK2 (EMPLOVEE_ID) SJOB_HISTORY F3 (MANAGER_ID) JOB_HISTORY FK4 (JOB_ID) O JOB_HISTORY PK (EMPLOYEE_ID, START_DATE) VARCHAR2 (30 BYTE) DATE MODIFIED_BY MODIFIED_DATE JOBS_PK (JOB_IO) • JOBS_PKJO8_10) Build the schema and one view, Build a sequence for each of these tables, sequence is valued using an insert trigger