ORACLE
dappy7000
EntityRelationshipDiagramfortheHRDatabase33.docEntity Relationship Diagram for the HR Database
|
HR.JOB_HISTORY |
|
employee_id (FK) |
|
start_date |
|
end_date |
|
job_id (FK) |
|
department_id (FK)
|
|
HR.EMPLOYEES |
|
employee_id (PK) |
|
first_name |
|
last_name |
|
|
|
phone_number |
|
hire_date |
|
job_id (FK) |
|
salary |
|
commission_pct |
|
manager_id |
|
department_id (FK) |
|
HR.JOBS |
|
job_id (PK) |
|
job_title |
|
max_salary |
|
min_salary |
|
HR.DEPARTMENTS |
|
department_id (PK) |
|
department_name |
|
location_id (FK) |
|
manager_id |
|
HR.LOCATIONS |
|
location_id (PK) |
|
street_address |
|
postal_code |
|
city |
|
state_province |
|
country_id (FK)
|
|
HR.COUNTRIES |
|
country_id (PK) |
|
country_name |
|
region_id (FK) |
|
HR.REGIONS |
|
region_id (PK) |
|
region_name |
