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

1. Is this in 1NF? Why or why not? If it isnt, then what change(s) need to be made to ensure its in 1NF?
2. 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.
3. Show the new tables with at least 3 rows of sample data for each