Use the E-R Diagram and execute the HR.SqL to create the initial setup and data for the lab assignment 1) E-R DIAGRAM

2)HR.SQL to create initial setup:

after sql setup answer the below questions 1 to 12:

https://dmaccblackboard.com/webapps/blackboard/execute/content/file?cmd-view&icontent id- 3270 - + Automatic Zoom ORAS1.STAFF ORA81.DEPARTMENT S ORA8 .LOCATIONS STAFF ID FIRST NAME LAST NAME EMAIL PHONE NUMBERVARCHAR2 (20 BYTE) HIRE DATE NUMBER (6) VARCHAR2 (20 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (25 BYTE) DEPARTMENT ID DEPARTMENT NAME VARCHAR2 (30 BYTE) MANAGER ID " LOCATION ID STREET ADDRESS VARCHAR2 (40 BYTE NUMBER4) NUMBER(4) POSTAL COOE NUMBER (8) NUMBER(4) VARCHAR2 (12 BYTE) VARCHAR2 (30 BYTE) F LOCATION STATE PROVINCEVARCHAR2 (25 BTE) DEPT 1D PK (DEPARTMENT ID) COUNTRY ID LOC ID PK (LOCATION ID) DATE CHAR (2 BYTE VARCHAR2 (10 BYTE NUMBER(82 DEPT LOC FK (LOCATION ID) DEPI MGR FK (MANAGER ID) LOC C ID FK (COUNTRY D) aL LOC CITY X (CITY DEPT 1D_PK (DEPARTMENT ID) :i. DEPT LOCATION-IX(LOCATION.-E)) EMP EMAIL ORA31JOB HISTORY NUMBER (6) DATE DATE VARCHAR2 (10 BYTE) :' EMP DEPARTMENT tX(DEPARTMENT-12 EMP EMAIL UK START-DATE END DATE DEPARTMENT ID NUMBER (4) FREGION ID EMP JOB X(JoB ID) EMP MANAGER ix MANAGER-D) EMP-NAME-IX(LAST-NAME, FIRST-NAME) COUNTRY CLID PK (COUNTRY JD) COUNTR REG FK (REGION ID) -COUNTRY-C-10-PK (COUNTRY-10) JHIST EMP ID ST DATE PK (STAFF ID, START DATE) S2 JHIST DEPT FK (DEPARTMENT ID) JHIST EMP FK (STAFF ID) JHISI -098 FK (JOB ID) YV JHSTDE PART MEN rix JH1ST-EMPLOYEE-IX(STAFF-E)) JHIST EMP ID ST DATE PK (STAFF DEPARTMENT-ID) : ID START DATE) ORAS1REGIONS NUMBER JHIST JOB IX (JOB ID) REGION-10 REGION NAME VARCHAR2 (25 BYTE) P ORA81 JOBS VARCHAR2 (10 BYTE) REG ID PK (REGION ID) REG ID PK (REGION ID) JOB TITLE VARCHAR2 (35 BYTE) MIN SALARY NUMBER (8) MAX SALARY NUMBER (6) JOB ID PK (JOB ID) https://dmaccblackboard.com/webapps/blackboard/execute/content/file?cmd-view&icontent id- 3270 - + Automatic Zoom ORAS1.STAFF ORA81.DEPARTMENT S ORA8 .LOCATIONS STAFF ID FIRST NAME LAST NAME EMAIL PHONE NUMBERVARCHAR2 (20 BYTE) HIRE DATE NUMBER (6) VARCHAR2 (20 BYTE) VARCHAR2 (25 BYTE) VARCHAR2 (25 BYTE) DEPARTMENT ID DEPARTMENT NAME VARCHAR2 (30 BYTE) MANAGER ID " LOCATION ID STREET ADDRESS VARCHAR2 (40 BYTE NUMBER4) NUMBER(4) POSTAL COOE NUMBER (8) NUMBER(4) VARCHAR2 (12 BYTE) VARCHAR2 (30 BYTE) F LOCATION STATE PROVINCEVARCHAR2 (25 BTE) DEPT 1D PK (DEPARTMENT ID) COUNTRY ID LOC ID PK (LOCATION ID) DATE CHAR (2 BYTE VARCHAR2 (10 BYTE NUMBER(82 DEPT LOC FK (LOCATION ID) DEPI MGR FK (MANAGER ID) LOC C ID FK (COUNTRY D) aL LOC CITY X (CITY DEPT 1D_PK (DEPARTMENT ID) :i. DEPT LOCATION-IX(LOCATION.-E)) EMP EMAIL ORA31JOB HISTORY NUMBER (6) DATE DATE VARCHAR2 (10 BYTE) :' EMP DEPARTMENT tX(DEPARTMENT-12 EMP EMAIL UK START-DATE END DATE DEPARTMENT ID NUMBER (4) FREGION ID EMP JOB X(JoB ID) EMP MANAGER ix MANAGER-D) EMP-NAME-IX(LAST-NAME, FIRST-NAME) COUNTRY CLID PK (COUNTRY JD) COUNTR REG FK (REGION ID) -COUNTRY-C-10-PK (COUNTRY-10) JHIST EMP ID ST DATE PK (STAFF ID, START DATE) S2 JHIST DEPT FK (DEPARTMENT ID) JHIST EMP FK (STAFF ID) JHISI -098 FK (JOB ID) YV JHSTDE PART MEN rix JH1ST-EMPLOYEE-IX(STAFF-E)) JHIST EMP ID ST DATE PK (STAFF DEPARTMENT-ID) : ID START DATE) ORAS1REGIONS NUMBER JHIST JOB IX (JOB ID) REGION-10 REGION NAME VARCHAR2 (25 BYTE) P ORA81 JOBS VARCHAR2 (10 BYTE) REG ID PK (REGION ID) REG ID PK (REGION ID) JOB TITLE VARCHAR2 (35 BYTE) MIN SALARY NUMBER (8) MAX SALARY NUMBER (6) JOB ID PK (JOB ID)