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 EMP TITLE Sales Agent Sales Agent Janitor DB Admin EMP DOB 23 Dec 1978 28 Mar 1979 18 May 1982 20 Jul 1959 EMP HIRE DATE 14 Oct 2007 15 Jan 2006 21 Apr 2013 15 Jul 1999 EMP TRAINING L1, L2 L1 L1, L3, L8, L15 EMP BASE SALARY $58,255 00 $60,500 00 $49 750 00 $127,900 00 EMP COMMISSION RATE 0 015 0 010 Is this in 1NF Why or why not If it isnt, then what change(s) need to be made to ensure its in 1NF Break this down to 2NF, and eventually 3NF by clearly working through the functional dependencies, partial dependencies and any transient dependencies to arrive at your final tables Show the new tables with at least 3 rows of sample data for each

The Answer is in the image, click to view ...

Question: 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,

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
EMP_TITLE	Sales Agent	Sales Agent	Janitor	DB Admin
EMP_DOB	23-Dec-1978	28-Mar-1979	18-May-1982	20-Jul-1959
EMP_HIRE_DATE	14-Oct-2007	15-Jan-2006	21-Apr-2013	15-Jul-1999
EMP_TRAINING	L1, L2		L1	L1, L3, L8, L15
EMP_BASE_SALARY	$58,255.00	$60,500.00	$49.750.00	$127,900.00
EMP_COMMISSION_RATE	0.015	0.010

Is this in 1NF? Why or why not? If it isnt, then what change(s) need to be made to ensure its in 1NF?
Break this down to 2NF, and eventually 3NF by clearly working through the functional dependencies, partial dependencies and any transient dependencies to arrive at your final tables.
Show the new tables with at least 3 rows of sample data for each

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