Question: The table structure below contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes and some attributes are not atomic. Table: Sample

The table structure below contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes and some attributes are not atomic.

Table: Sample EMPLOYEE Records

Attribute Name

Sample Value

Sample Value

Sample Value

Sample Value

EMP_NUM

1003

1018

1019

1023

EMP_LNAME

Willaker

Smith

McGuire

McGuire

EMP_EDUCATION

BBA, MBA

BBA

BS, MS, Ph.D.

JOB_CLASS

SLS

SLS

JNT

DBA

EMP_DEPENDENTS

Gerald (spouse),

Mary (daughter),

John (son)

JoAnne (spouse)

George (spouse)

Jill (daughter)

DEPT_CODE

MKTG

MKTG

SVC

INFS

DEPT_NAME

Marketing

Marketing

General Service

Info. Systems

DEPT_MANAGER

Jill H. Martin

Jill H. Martin

Hank B. Jones

Carlos G. Ortez

JOB_TITLE

Sales Agent

Sales Agent

Janitor

DB Admin

EMP_DOB

23-Dec-1968

28-Mar-1979

18-May-1982

20-Jul-1959

EMP_HIRE_DATE

14-Oct-1997

15-Jan-2006

21-Apr-2003

15-Jul-1999

EMP_TRAINING

L1, L2

L1

L1, L3, L8, L15

EMP_SALARY

$38,255.00

$30,500.00

$19.750.00

$127,900.00

b. Draw the dependency diagrams that are in 3NF. (Hint: You might have to create some new tables and columns. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria, e.g., there are no multivalued attributes)

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 Databases Questions!