Small Exercise - Chapter 6 Normalization Profs and Students ITCS 3160 You are given the table below, which was imported from an Excel spreadsheet. The data reflect that a professor can have multiple advisees and serve on multiple committees. Attribute Name Sample Value Sample Sample Value Sample Value Value 123 Professor 104 Asst. Professor 118 Assoc Professor Ortega CIS Computer Info Svstems KDD-562 2134 EMP NUM PROF RANK ASSo Professor Smith ENG English Ghee CIS Computer Info Systems KDD-567 1215, 2312 EMP NAME DEPT CODE DEPT NAME Rankin CHEM Chemistry PROF OFFICE ADVISEE NUM BLF-119 3102, 2782, 3311 PRT-345 2873, 2765 ADVISEE NAME Gray, Simon Bobbit Kerr, Smythe, Francis DEV Bitner, Collins PROMO COMMITTEE CODE PROMO, TRAF SPR, TRAF Convert the data in the table to a database normalized to 3NF. Draw the EERD reflecting 3NF. Small Exercise - Chapter 6 Normalization Profs and Students ITCS 3160 You are given the table below, which was imported from an Excel spreadsheet. The data reflect that a professor can have multiple advisees and serve on multiple committees. Attribute Name Sample Value Sample Sample Value Sample Value Value 123 Professor 104 Asst. Professor 118 Assoc Professor Ortega CIS Computer Info Svstems KDD-562 2134 EMP NUM PROF RANK ASSo Professor Smith ENG English Ghee CIS Computer Info Systems KDD-567 1215, 2312 EMP NAME DEPT CODE DEPT NAME Rankin CHEM Chemistry PROF OFFICE ADVISEE NUM BLF-119 3102, 2782, 3311 PRT-345 2873, 2765 ADVISEE NAME Gray, Simon Bobbit Kerr, Smythe, Francis DEV Bitner, Collins PROMO COMMITTEE CODE PROMO, TRAF SPR, TRAF Convert the data in the table to a database normalized to 3NF. Draw the EERD reflecting 3NF