Create a simple HR database based on below model. You should have 8 tables in total...

 

Transcribed Image Text:

Create a simple HR database based on below model. You should have 8 tables in total in your Database. The table columns are given on the left side and their respective data type is given on the right. regions REGION_ID REGION NAME departments DEPARTMENT ID NUMBER DEPARTMENT NAME VARCHAR2(30) MANAGER ID LOCATION ID job_history NUMBER VARCHAR2(25) EMPLOYEE ID START_DATE END DATE JOB ID DEPARTMENT ID NUMBER NUMBER NUMBER DATE DATE VARCHAR2(10) NUMBER 81 countries COUNTRY_ID CHAR(2) COUNTRY NAME VARCHAR2(40) REGION_ID NUMBER employees EMPLOYEE ID FIRST NAME LAST NAME EMAIL PHONE NUMBER HIRE DATE JOB ID SALARY COMMISSION PCT NUMBER MANAGER ID NUMBER VARCHAR2(20) VARCHAR2(25) VARCHAR2(25) VARCHAR2(20) DATE VARCHAR2(10) NUMBER NUMBER DEPARTMENT_ID NUMBER 81 locations LOCATION ID NUMBER STREET ADDRESS VARCHAR2(25) POSTAL CODE VARCHAR2(12) VARCHAR2(30) VARCHAR2(12) CHAR(2) CITY STATE PROVINCE COUNTRY_ID jobs JOB ID VARCHAR2(10) JOB_TITLE VARCHAR2(35) MIN SALARY NUMBER MAX SALARY NUMBER job_grades GRADE LEVEL VARCHAR2(2) LOWEST SAL HUMBER HIGHEST SAL HUMBER Question 2 (5 mark) Create a simple Movie database based on below model. You should have 9 tables in total in your Database. The table columns are given on the left side and their respective data type is given on the right. actor act_id act_fname act_Iname act_gender director dir_id dir_fname dir Iname movie_direction dir_id mov_id integer char (20) char (20) char (1) integer char (20) char (20) integer integer movie cast act_id mov_id role movie mov id mov_title mov year integer char (50) integer integer char (50) date mov_rel_country| char (5) mov_time mov_lang mov_dt_rel reviewer integer integer char (30) rev_id rev_name integer char (30) 18 18 genres gen_id gen_title movie_genres mov_id gen_id rating mov_id rev_id rev_stars integer char (20) integer integer integer integer integer num_o_ratings integer Create a simple HR database based on below model. You should have 8 tables in total in your Database. The table columns are given on the left side and their respective data type is given on the right. regions REGION_ID REGION NAME departments DEPARTMENT ID NUMBER DEPARTMENT NAME VARCHAR2(30) MANAGER ID LOCATION ID job_history NUMBER VARCHAR2(25) EMPLOYEE ID START_DATE END DATE JOB ID DEPARTMENT ID NUMBER NUMBER NUMBER DATE DATE VARCHAR2(10) NUMBER 81 countries COUNTRY_ID CHAR(2) COUNTRY NAME VARCHAR2(40) REGION_ID NUMBER employees EMPLOYEE ID FIRST NAME LAST NAME EMAIL PHONE NUMBER HIRE DATE JOB ID SALARY COMMISSION PCT NUMBER MANAGER ID NUMBER VARCHAR2(20) VARCHAR2(25) VARCHAR2(25) VARCHAR2(20) DATE VARCHAR2(10) NUMBER NUMBER DEPARTMENT_ID NUMBER 81 locations LOCATION ID NUMBER STREET ADDRESS VARCHAR2(25) POSTAL CODE VARCHAR2(12) VARCHAR2(30) VARCHAR2(12) CHAR(2) CITY STATE PROVINCE COUNTRY_ID jobs JOB ID VARCHAR2(10) JOB_TITLE VARCHAR2(35) MIN SALARY NUMBER MAX SALARY NUMBER job_grades GRADE LEVEL VARCHAR2(2) LOWEST SAL HUMBER HIGHEST SAL HUMBER Question 2 (5 mark) Create a simple Movie database based on below model. You should have 9 tables in total in your Database. The table columns are given on the left side and their respective data type is given on the right. actor act_id act_fname act_Iname act_gender director dir_id dir_fname dir Iname movie_direction dir_id mov_id integer char (20) char (20) char (1) integer char (20) char (20) integer integer movie cast act_id mov_id role movie mov id mov_title mov year integer char (50) integer integer char (50) date mov_rel_country| char (5) mov_time mov_lang mov_dt_rel reviewer integer integer char (30) rev_id rev_name integer char (30) 18 18 genres gen_id gen_title movie_genres mov_id gen_id rating mov_id rev_id rev_stars integer char (20) integer integer integer integer integer num_o_ratings integer

Answer rating: 100% (QA)

1 Based on the provided model we can create a simple HR database with 8 tables using SQL Below is the SQL script for creating these tables CREATE TABLE regions regionid NUMBER PRIMARY KEY regionname V... View the full answer