This image shows the database schema for the sample applications. It shows three tables: EMPLOYEES, EMPLOYEE_BENEFIT_ITEMS, and BENEFITS.
The EMPLOYEES table contains these fields:
Employee_ID
First_name
Last_name
Phone_number
Hire_date
Job_id
Salary
Commission_pct
Manager_id
Department_id
The BENEFITS table contains these fields:
Benefit_id
Benefit_name
Benefit_description
The EMPLOYEE_BENEFIT_ITEMS table contains these fields:
Employee_ID
Benefit_id
Election_date
The EMPLOYEES table is connected to the EMPLOYEE_BENEFIT_ITEMS table through the Employee_ID field. Similarly, the BENEFITS table is connected to the EMPLOYEE_BENEFIT_ITEMS table through the Benefit_id field. However, the EMPLOYEES table has no direct connection to the BENEFITS table.