Lab 1

Owned by Computer Science Department
Last updated: Aug 05, 2023
1 min read

 Objective

Given the following table data, complete the following questions and activities.

Table: EMPLOYEE

EMP_CODE

EMP_LASTNAME

JOB_CODE

14

Raymond

2

15

Smith

1

16

Jones

1

17

Roark

2

18

Hernandez

3

Table: BENEFIT

EMP_CODE

PLAN_CODE

15

2

15

3

16

1

17

1

17

3

Table: JOB

JOB_CODE

JOB_DESCRIPTION

1

Technical (IT)

2

Professor

3

Enrollment Advisor

Table: PLAN

PLAN_CODE

PLAN_DESCRIPTION

1

Term Life

2

401K

3

Health

4

Dental

 

Copy and paste the Questions table to a Word document with your responses

 Questions

Requirement

Responses

Requirement

Responses

List the likely Primary Keys for each table.

List in your Word document submission

List the table/attribute of any foreign key if one exists.

List in your Word document submission

Create an ERD for the above tables. You can use LucidCharts, Miro, or Visio.

Add a screenshot of your ERD to your word document upload.

 

Â