Question: using oracle Create a simple HR database based on below model. You should have 8 tables in total in your Database. The table columns are

using oracle Create a simple HR database based on below model. You using oracle

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 countries locations REGION_ID NUMBER REGION NAME VARCHAR2(25) COUNTRY_ID CHAR(2) COUNTRY NAME VARCHAR2(40) REGION_ID NUMBER LOCATION ID NUMBER STREET ADDRESS VARCHAR2(25) POSTAL CODE VARCHAR2(12) CITY VARCHAR2(30) STATE PROVINCE VARCHAR2(12) COUNTRY_ID CHAR(2) 00 departments employees DEPARTMENT ID NUMBER oo DEPARTMENT_NAME VARCHAR2(30) MANAGER ID NUMBER LOCATION_ID NUMBER 00 EMPLOYEE_ID FIRST NAME LAST_NAME EMAIL PHONE_NUMBER HIRE DATE JOB.ID SALARY COMMISSION PCT MANAGER ID DEPARTMENT_ID NUMBER VARCHAR2(20) VARCHAR2(25) VARCHAR2(25) VARCHAR2(20) DATE VARCHAR2(10) NUMBER NUMBER NUMBER NUMBER jobs JOB_ID VARCHAR2(10) JOB_TITLE VARCHAR2(35) MIN_SALARY NUMBER MAX_SALARY NUMBER 81 job_history NUMBER DATE og job_grades EMPLOYEE ID START_DATE END DATE JOB_ID DEPARTMENT_ID DATE oo VARCHAR2(10) NUMBER GRADE LEVEL VARCHAR2(2) LOWEST SAL NUMBER HIGHEST SAL NUMBER

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

use oracle please 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...

Project 1D Certification Events Microsoft Access Apply 1B skills from these Objectives: 6 Use a Template 10 Greate a Database 7 Organise Objects in the Navigation Pane 8 Create a New Table in...

4: Decision Making and Improving Supply Chain Management (Excel Exercise) Due: March 25, 2012 Total Score: 30 Points Part A: Springville School District Student and Teacher Ratio Problem Attention:...

Logical data models, or relational models in our case, consist of tables and their PKs, FKs, and attributes to represent conceptual data models (e.g., ERD) in the structure of the relational...

Practice Section You may want to download and open the Practice Database in Lesson 4 in Microsoft Access (Admissions Student Database.mdb; Please note that this database is graciously provided...

8. Insert two new table columns to the right of Price in the productsavors table, and label those new columns "Order Count" and "Total Volume", Use a COUNTIF function to populate the Order Count...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

SHIPMENT_LINE SHIP_ID INV_ID SL_QUANTITY SL_DATE_RECEIVED Number Number Number Date/ Time 25 09/10/2006 2 25 09/10/2006 2 25 5 200 6 200 7 200 12 100 08/15/2006 13 100 08/25/2006 23 50 08/15/2006 24...

Q1. Think of ten different types of electronic information that you access, or share, on a regular basis. Consider how these transactions have changed over the last 5-10 years. Q2. Now apply this...

Refer to the infinite slope shown in Figure 15.47. Given: ( = 25°, ( = 17.8 kN/m3, (' = 28°, and c' = 31 kN/m2. Find the height, H, such that a factor of safety, Fs, of 2.75 is maintained...

For European options, what is the effect of an increase in the strike price E ? Decrease the value of cals, increase the value of puts, ceteris poribus Decrease the value of cals and puts, ceteris...

After watching the video, list at least 2 points where Direct Labor is applied to production ( Recall Direct Labor can be observed, and easily and conveniently traced to production ) . Be as specific...

How are members held accountable for serving in the assigned roles?

Which members would you want back in your team and which would you not?

Have roles been defined and assigned?