Module3 homework assignment

Module3 homework assignment - REGION_CODE NONE 9. Table...

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 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
8. Table Primary Key Foreign Key(s) EMPLOYEE EMP_CODE STORE_CODE STORE STORE_CODE REGION_CODE and EMP_CODE REGION
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: REGION_CODE NONE 9. Table ENITITY INTEGRITY EXPLANATION EMPLOYEE YES Each value is unique. No null values. STORE YES Each value is unique. No null values. REGION YES Each value is unique. No null values. 10. Table ENITITY INTEGRITY EXPLANATION EMPLOYEE YES The values EMPLOYEE/STORE_CODE all exist in STORE/STORE_CODE. STORE YES The values STORE /REGION_CODE all exist in REGION/REGION_CODE. The values STORE/EMP_CODE all exist in EMPLOYEE/EMP_CODE. REGION N/A N/A 14. a. The STORE employs EMPLOYEE. This is a 1:M relationship. The store employs many employees. b. The EMPLOYEE manages STORE. This is a 1:1 relationship. One employee manages a store....
View Full Document

Page1 / 3

Module3 homework assignment - REGION_CODE NONE 9. Table...

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