In the lecture, we discussed normalization. The two datasets below are not normalized yet, so we should normalize the datasets into 3NF tables. Show the normalization steps for each dataset using the format provided in the example. Example) 1 NF:PROJECT (ProjectNum, Proj_Name, Start_Date, Emp_Num, Emp_Name, Job_Class) 2 NF:PROJECT (ProjectNum, Proj_Name, Start_Date) EMP(Emp_Num, Emp_Name, Job_Class) 3 NF:PROJECT (ProjectNum, Proj_Name, Start_Date) EMP(Emp_Num, Emp_Name, Job_Class) ** Bold and underline the primary key Dataset #2 (Attribute names are in the first column)1018SmithBBASLSEMP_NUMEMP LNAMEEMP EDUCATIONJOB CLASSEMP DEPENDENTSDEPT CODEDEPT NAMEDEPT_MANAGEREMP_TITLEEMP DOBEMP HIRE DATEEMP TRAININGEMP BASE SALARYEMP_COMMISSION RATE1003WillakerBBA, MBASLSGerald (spouse),Mary (daughter),John (son)MKTGMarketingJill H. MartinSales Agent23-Dec-196814-Oct-1997L1, L2$38,255.000.015MKTGMarketingJill H. MartinSales Agent28-Mar-197915-Jan-2006L1$30,500.000.0101019McGuireUNTJoAnne (spouse)SVCGeneral ServiceHank B. JonesJanitor18-May-198221-Apr-2003L1$19,750.001023McGuireBS, MS, Ph.D.DBAGeorge (spouse)Jill (daughter)INFSInfo. SystemsCarlos G. OrtezDB Admin20-Jul-195915-Jul-1999L1, L3, L8, L15$127,900.00

Answered: n the lecture, we discussed…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

In the lecture, we discussed normalization. The two datasets below are not normalized yet, so we should normalize the datasets into 3NF tables. Show the normalization steps for each dataset using the format provided in the example.

Example)

1 NF:

PROJECT (ProjectNum, Proj_Name, Start_Date, Emp_Num, Emp_Name, Job_Class)

2 NF:

PROJECT (ProjectNum, Proj_Name, Start_Date)

EMP(Emp_Num, Emp_Name, Job_Class)

3 NF:

PROJECT (ProjectNum, Proj_Name, Start_Date)

EMP(Emp_Num, Emp_Name, Job_Class)

** Bold and underline the primary key

Dataset #2 (Attribute names are in the first column)
1018
Smith
BBA
SLS
EMP_NUM
EMP LNAME
EMP EDUCATION
JOB CLASS
EMP DEPENDENTS
DEPT CODE
DEPT NAME
DEPT_MANAGER
EMP_TITLE
EMP DOB
EMP HIRE DATE
EMP TRAINING
EMP BASE SALARY
EMP_COMMISSION RATE
1003
Willaker
BBA, MBA
SLS
Gerald (spouse),
Mary (daughter),
John (son)
MKTG
Marketing
Jill H. Martin
Sales Agent
23-Dec-1968
14-Oct-1997
L1, L2
$38,255.00
0.015
MKTG
Marketing
Jill H. Martin
Sales Agent
28-Mar-1979
15-Jan-2006
L1
$30,500.00
0.010
1019
McGuire
UNT
JoAnne (spouse)
SVC
General Service
Hank B. Jones
Janitor
18-May-1982
21-Apr-2003
L1
$19,750.00
1023
McGuire
BS, MS, Ph.D.
DBA
George (spouse)
Jill (daughter)
INFS
Info. Systems
Carlos G. Ortez
DB Admin
20-Jul-1959
15-Jul-1999
L1, L3, L8, L15
$127,900.00

Expert Solution

Step 1

datasets below are not normalized yet, so we should normalize the datasets into 3NF tables.

see the below

Thank You

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions