Given the following database instance, answer questions 3.1 through 3.3:

Employee				Plan
emp_code	emp_lname	job_code		plan_code	plan_description
EC14	Rudell	JC2		1	Term Life
EC15	McDade	JC1		2	Stock Purchase
EC16	Ruellardo	JC1		3	Long-term disability
EC17	Smith	JC3		4	Dental
EC20	Smith	JC2
Job				Benefit
job_code	job_description			emp_code	plan_code
JC1	Clerical			EC15	3
JC2	Technical			EC16	1
JC2	DBA			EC17	1
JC3	Manager			EC17	3
				EC17	4
Extra_Benefit				EC20	3
job_code	plan_code
JC3	2

Assume that the following attributes are the primary keys for the tables:

emp_code is the primary key for Employee table

job_code is the primary key for the Job table

plan_code is the primary key for the Plan table

emp_code, plan_code is a composite primary key for the Benefit table

job_code, plan_code is the composite primary key for the Extra_Benefit table

(2 Points) Do all tables exhibit entity integrity? Answer yes or no and then explain your answer for each table

3.2 (2 Points) For each table in the database, identify foreign key(s) (if any). For each foreign key, state the referencing relation and the referenced relation.

3.3 (2 Points) Do all tables exhibit referential integrity? Answer yes or no and then explain your answer for each table