Suppose that you have been given the table structure and data shown in Table 6.9, which was imported from an Excel spreadsheet. The data reflect that a professor can have multiple advisees, can serve on multiple committees, and can edit more than one journal.

a. Draw the dependency diagram.
b. Identify the multivalued dependencies.
c. Create the dependency diagrams to yield a set of table structures in 3NF.
d. Eliminate the multivalued dependencies by converting the affected table structures to 4NF.
e. Draw the Crow’s Foot ERD to reflect the dependency diagrams you drew in Partc.

Transcribed Image Text:

Attribute Name Sample Value Sample Value Sample Value Sample Value EMP NUM PROF RANK EMP NAME DEPT CODE DEPT NAME 123 Professor Ghee CIS Computer Info. Chemistry Systems KDD-567 104 Asst. Professor Rankin CHEM 118 Assoc. ProfessorAssoc. Professor Ortega CIS Computer Info. English Systems KDD-562 Smith ENG PROF OFFICE BLF-119 PRT-345 ADVISEE1215, 2312, 3233, 3102, 2782, 3311, 2134,2789, 3456, 2873,2765, 2238, 2218, 2098 2008, 2876, 2222, 2002, 2046, 2018, 2901,2308 3745, 1783, 2378 2764 PROMO, SPR DEV COMMITTEE CODE PROMO, TRAF DEV SPR, TRAF APPL, DEV JOURNAL CODE JMIS, QED, ICIS, MIGT JMGT