Q1) Find 1NF, 2NF and 3NF for the following table ATTRIBUTE NAME STU NUM STU_LNAME STU MAJOR DEPT CODE DEPT_NAME DEPT PHONE COLLEGE NAME ADVISOR_LNAME ADVISOR OFFICE ADVISOR BLDG ADVISOR PHONE STU GPA STU_HOURS STU CLASS SAMPLE VALUE 211343 Stephanos Accounting ACCT Accounting 4356 Business Admin Grastrand T201 Torre Building 2115 3.87 75 Junior SAMPLE VALUE 200128 Smith Accounting ACCT Accounting 4356 Business Admin Grastrand T201 Torre Building 2115 2.78 45 Sophomore SAMPLE VALUE 199876 Jones Marketing MKTG Marketing 4378 Business Admin Gentry T228 Torre Building 2123 2.31 117 Senior SAMPLE VALUE 199876 Ortiz Marketing MKTG Marketing 4378 Business Admin Tillery T356 Torre Building 2159 3.45 113 Senior SAMPLE VALUE 223456 McKulski Statistics MATH Mathematics 3420 Arts & Sciences Chen J331 Jones Building 3209 3.58 87 Junior Q2) Find 1NF, 2NF and 3NF for the following table EMP NUM EMP LNAME EMP EDUCATION JOB CLASS EMP DEPENDENTS 1003 Willaker BBA, MBA 1019 McGuire 1018 Smith BBA SLS 1023 McGuire BS, MS, Ph.D. DBA George (spouse) Jill (daughter) SLS JNT JoAnne (spouse) 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 SVC General Service Hank B. Jones Janitor 18-May-1982 21-Apr-2003 L1 $19,750.00 INFS Info. Systems Carlos G. Ortez DB Admin 20-Jul-1959 15-Jul-1999 L1, L3, L8,L15 $127,900.00