Scribd
Upload
7 views2 pages

HR Database Table Box

The document outlines a database schema with tables for regions, countries, locations, departments, jobs, and employees. It includes details such as region names, country associations, location addresses, department names, job titles with salary ranges, and employee information. The data reflects a structured organization of geographical and employment-related information.

Uploaded by

sadhumanoj776
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views2 pages

HR Database Table Box

The document outlines a database schema with tables for regions, countries, locations, departments, jobs, and employees. It includes details such as region names, country associations, location addresses, department names, job titles with salary ranges, and employee information. The data reflects a structured organization of geographical and employment-related information.

Uploaded by

sadhumanoj776
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

REGIONS

region_id | region_name

1 | Europe

2 | Americas

3 | Asia

4 | Middle East

COUNTRIES

country_id | country_name | region_id

US | United States | 2

IN | India | 3

UK | United Kingdom | 1

CN | China | 3

LOCATIONS

location_id | street_address | postal_code | city | state_province | country_id

1000 | 1297 Via Cola | 00989 | Roma | Lazio | IT

1100 | 93091 Calle Della | 10934 | Venice | Veneto | IT

1200 | MG Road | 600001 | Chennai | TN | IN

DEPARTMENTS

department_id | department_name | manager_id | location_id

10 | Administration | 200 | 1000

20 | Marketing | 201 | 1100

30 | IT | 202 | 1200

JOBS

job_id | job_title | min_salary | max_salary

IT_PROG | Programmer | 4000 | 10000

HR_REP | HR Representative | 3000 | 8000

AD_ASST | Admin Assistant | 2500 | 6000

EMPLOYEES

employee_id | first_name | last_name | email | phone | hire_date | job_id | salary | commission_pct |


department_id

101 | John | Smith | JSMITH | 9876543210 | 2022-01-10 | IT_PROG | 8000 | NULL | 30

102 | Priya | Kumar | PKUMAR | 9123456780 | 2021-06-15 | HR_REP | 6000 | 0.10 | 20

103 | David | Brown | DBROWN | 9988776655 | 2020-03-20 | AD_ASST | 4500 | NULL | 10

You might also like