Question: Consider the following figure. Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB_CODE 14 Rudell 2 15 McDade 1 16 Ruellardo 1 17 Smith 3 20 Smith 2.

Consider the following figure. Table name:

Consider the following figure. Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB_CODE 14 Rudell 2 15 McDade 1 16 Ruellardo 1 17 Smith 3 20 Smith 2. Table name: BENEFIT EMP_CODE PLAN_CODE 15 2 15 3 16 1 17 1 17 3 17 4 20 3 3 Table name: JOB JOB_CODE JOB_DESCRIPTION 1 Clerical 2 Technical 3 Managerial Table name: PLAN PLAN_CODE PLAN_DESCRIPTION 1 Term lite 2 Stock purchase 3 Long-term disability 4 Dental Which of the following attributes would help solve the entity integrity issue? Oadding a primary key to benefit adding a surrogate primary key to benefit adding a primary key to employee adding a surrogate primary key to employee adding a primary key to job adding a surrogate primary key to job adding a primary key to plan adding a surrogate primary key to plan

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!