Question
Use the E-R Diagram to create jobs table and Regions table.
e?cmdsview&content ids 3270734. 1sicourse.id: 62879.1 RA3321 LOCATION ID STREET ADDRESS VARCHAR2 (40 BYTE) POSTAL CODE CITY STATE-PROVINCE VARCHAR2 (25 BYTE) COUNTRY ID NUMBER (4) VARCHAR2 (12 BYTE) VARCHAR2 (30 BYTE) ORA332 DEPARTMENTS DEPARTMENTD DEPARTMENT NAVEVAROHARE D BYTE MANAGER ID NUMBER ( NUMBER) NUMBER 4 F , LOCATION-ID 2EMPLOYEES EMPLOYEELID NUMBER ) VARCHAR2 CO BYTE) VARCHAR2 (25 VARCHAR2 (20 BYTE) FIRST NAME 1LAST NAME MAIL PHONE NUMBERVARCHAR2 20 BYTE) HIRE OATE DATE VARCHARZ CO YTE NUMBER 8 2) NUMBER 02) NUMBER () NUMBER (4) SALARY COMMISSION PCT MANAGERO DEPARTMENT-O ORA332 COUNTRIES ORA332 JOB HISTORY COUNTRY ID CHAR (2 BYTE) NUMBER () DATE DATE VARCHAR2 (10 BYTE) PF" EMPLOYEE ID COUNTRY NAME VARCHAR2 (40 BYTE) REGION ID START DATE NUMBER END DATE JOB ID F DEPARTMENT ID NUMBER (4) VARCHAR2 110 BYTE) JOB TITLEWARCHAR2 35 SYTE) MIN-SALARY NUMBER (B) MAX SALARY NUMBER e) ORA332 REGIONS 527 PM REGION ID NUMBER M E.@rP.. 9.ans e É a
Explanation / Answer
If you have any doubts, please give me comment...
CREATE TABLE ORA332_JOBS(
JOB_ID VARCHAR2(10) NOT NULL PRIMARY KEY,
JOB_TITLE VARCHAR2(35),
MIN_SALARY NUMBER(8),
MAX_SALARY NUMBER(8)
);
CREATE TABLE ORA332_REGIONS(
REGION_ID NUMBER NOT NULL PRIMARY KEY,
REGION_NAME VARCHAR(30)
);
