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
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am