TimothyMartens_assignment3

TimothyMartens_assignment3 - 1. Table EMPLOYEE BENEFIT JOB...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1. Table Primary Key Foreign Key(s) EMPLOYEE EMP_CODE JOB_CODE BENEFIT EMP_CODE + PLAN_CODE EMP_CODE  and  PLAN_CODE JOB JOB_CODE NONE PLAN PLAN_CODE NONE 4. Table ENITITY  INTEGRITY EXPLANATION EMPLOYEE YES Each value is unique. No null values. BENEFIT YES Each value EMP_CODE and PLAN_CODE(together) is  unique JOB YES Each value is unique. No null values. PLAN YES Each value is unique. No null values. 5. Table REFERNTIAL  INTEGRITY EXPLANATION EMPLOYEE YES The values EMPLOYEE/JOB_CODE all exist in  JOB/JOB_CODE. BENEFIT YES The values BENIFIT/EMP_CODE all exist in EMPLOYEE/ EMP_CODE. The values BENIFIT/PLAN_CODE all exist in  PLAN/PLAN_CODE. JOB N/A N/A PLAN N/A N/A 8. Table Primary Key Foreign Key(s) EMPLOYEE EMP_CODE STORE_CODE
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
STORE STORE_CODE REGION_CODE and  EMP_CODE REGION REGION_CODE
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

TimothyMartens_assignment3 - 1. Table EMPLOYEE BENEFIT JOB...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online