Ch.3 problems

Ch.3 problems - nulls. 5. TABLE REFERENTIAL INTEGRITY...

Info iconThis preview shows pages 1–3. 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, PLAN_CODE JOB JOB-CODE None PLAN PLAN_CODE None 2. 3. 4. TABLE ENTITY INTEGRITY EXPLANATION EMPLOYEE Yes Each EMP_CODE value is unique and there are no  nulls. BENEFIT Yes Each   combination   of   EMP_CODE   and  PLAN_CODE values is unique and there are no nulls. JOB Yes Each JOB_CODE value is unique and there are no  nulls. PLAN Yes Each PLAN_CODE value is unique and there are no 
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: nulls. 5. TABLE REFERENTIAL INTEGRITY EXPLANATION EMPLOYEE Yes Each JOB_CODE value in EMPLOYEE points to an existing JOB_CODE value in JOB. BENEFIT Yes Each EMP_CODE value in BENEFIT points to an existing EMP_CODE value in EMPLOYEE and each PLAN_CODE value in BENEFIT points to an existing PLAN_CODE value in PLAN. JOB NA PLAN NA 6. 7....
View Full Document

Page1 / 3

Ch.3 problems - nulls. 5. TABLE REFERENTIAL INTEGRITY...

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

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