CH 3 Assignment

.docx

School

Northeastern University *

*We aren’t endorsed by this school

Course

2300

Subject

Business

Date

Feb 20, 2024

Type

docx

Pages

2

Uploaded by SuperArtAnteater36

Report
ITC 2300 Chapter 3 – Assignment Sanjesh Manandhar 10.  Identify the primary key and the foreign key(s). 8 Points (2 points for each table) = Table: EMPLOYEE Primary Key: EMP_CODE Foreign Key: JOB_CODE Table: JOB Primary Key: JOB_CODE Foreign Key: None Table: BENIFIT Primary Key: None Foreign Key: None Table: PLAN Primary Key: PLAN_CODE Foreign Key: None 13. Do the tables exhibit entity integrity? 8 Points (2 points for each table) = Table: EMPLOYEE Yes, the table EMPLOYEE exhibits Entity Integrity. It is because JOB_CODE acts as a Foreign Key in the table referring to the Primary Key of the JOB table. Table: JOB Yes, the table JOB exhibits Entity Integrity. It is because every value of Primary Key, JOB_CODE is unique and there are no null values.
ITC 2300 Chapter 3 – Assignment Sanjesh Manandhar Table: BENEFIT Yes, the table BENEFIT exhibits Entity Integrity. It is because two foreign keys EMP_CODE and PLAN_CODE refer to the primary keys of EMPLOYEE and PLAN tables respectively. Table: PLAN Yes, the table PLAN exhibits Entity Integrity. It is because every value of the Primary Key, PLAN_CODE is unique and there are no null values. 14. Do the tables exhibit referential integrity? 8 Points (2 points for each table) = Table: EMPLOYEE Yes, the table EMPLOYEE exhibits Referential Integrity. It is because every value of the Primary Key, EMP_CODE is unique and there is no null value. Table: JOB No, the table JOB does not exhibit Referential Integrity. It is because every value of JOB table does not have any Foreign Key. Table: BENEFIT Yes, the table BENEFIT exhibits Referential Integrity. It is because every combinational value of the Composite Primary Key, EMP_CODE and PLAN_CODE is unique and there are no null values. Table: PLAN No, the table PLAN does not exhibit Referential Integrity. It is because every value of the table PLAN does not have any Foreign Key.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help