Benifit Employee Job Plan
Posted: Tue Jul 12, 2022 8:15 am
Benifit
Employee
Job
Plan
* EMP_CODE 15 15 16 17 17 17 20 0 PLAN_CODE 2 3 1 1 3 4 3 0 Click to Add
* + + + + + EMP_CODE EMP_LNAME 14 Rudell 15 McDade 16 Ruellardo 17 Smith 20 Smith 0 JOB_CODE 2 1 1 3 2 0 Click to Add
* + + + JOB_CODE JOB_DESCRIPTION 1 Clerical 2 Technical 3 Managerial 0 Click to Add
米 + + + + PLAN_CODE PLAN_DESCRIPTION 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental 0 Click to Add
1. Identify the primary and foreign keys for each of the tables in the Ch03_BeneCo database. Answer "none" if a table has no foreign keys. Type your answers in the empty cells of the following table. (40 points) Primary Key (PK) Foreign Key (FK) EMPLOYEE BENEFIT JOB PLAN
- Benifit Employee Job Plan 1 (4.87 KiB) Viewed 26 times
- Benifit Employee Job Plan 2 (6.46 KiB) Viewed 26 times
- Benifit Employee Job Plan 3 (4.67 KiB) Viewed 26 times
- Benifit Employee Job Plan 4 (5.39 KiB) Viewed 26 times
- Benifit Employee Job Plan 5 (11.93 KiB) Viewed 26 times
* + + + + + EMP_CODE EMP_LNAME 14 Rudell 15 McDade 16 Ruellardo 17 Smith 20 Smith 0 JOB_CODE 2 1 1 3 2 0 Click to Add
* + + + JOB_CODE JOB_DESCRIPTION 1 Clerical 2 Technical 3 Managerial 0 Click to Add
米 + + + + PLAN_CODE PLAN_DESCRIPTION 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental 0 Click to Add
1. Identify the primary and foreign keys for each of the tables in the Ch03_BeneCo database. Answer "none" if a table has no foreign keys. Type your answers in the empty cells of the following table. (40 points) Primary Key (PK) Foreign Key (FK) EMPLOYEE BENEFIT JOB PLAN