Find 1NF, 2NF and 3NF for the following table EMP_NUM 1003 1018 EMP_LNAME Willaker Smith BBA,...

 

Transcribed Image Text:

Find 1NF, 2NF and 3NF for the following table EMP_NUM 1003 1018 EMP_LNAME Willaker Smith BBA, MBA BBA SLS SLS 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 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 INT 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 Find 1NF, 2NF and 3NF for the following table EMP_NUM 1003 1018 EMP_LNAME Willaker Smith BBA, MBA BBA SLS SLS 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 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 INT 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