Assignment Problem: Suppose that you have been given the table structure and data shown in Table below, 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.
Table: Sample PROFESSOR Records
|
Attribute Name
|
Sample Value
|
Sample Value
|
Sample Value
|
Sample Value
|
|
EMP_NUM
|
123
|
104
|
118
|
|
|
PROF_RANK
|
Professor
|
Asst. Professor
|
Assoc. Professor
|
Assoc. Professc
|
|
EMP_NAME
|
Ghee
|
Rankin
|
Ortega
|
Smith
|
|
DEPT_CODE
|
CIS
|
CHEM
|
CIS
|
ENG
|
|
DEPT_NAME
|
Computer Info. Systems
|
Chemistry
|
Computer Info. Systems
|
English
|
|
PROF_OFFICE
|
KDD-567
|
BLF-119
|
KDD-562
|
PRT-345
|
|
ADVISEE
|
1215, 2312,
|
3102, 2782, 3311, 2008, 2876, 2222, 3745, 1783,
|
2134, 2789, 3456, 2002, 2046, 2018, 2764
|
2873, 2765, 222
|
|
|
|
|
3233,
|
2378
|
2901, 2308
|
|
|
|
|
2218, 2098
|
|
|
|
COMMITTEE_CODE
|
PROMO, TRAF APPL, DEV
|
DEV
|
SPR, TRAF
|
PROMO, SPR DEV
|
|
JOURNAL_CODE
|
JMIS, QED, JMGT
|
|
JCIS, JMGT
|
|
Given the information in Table:
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. Draw the Crow's Foot ERD to reflect the dependency diagrams you drew in Part c. (Note: You might have to create additional attributes to define the proper PKs and FKs. Make sure that all of your attributes conform to the naming conventions.)
By availing our Dependency Diagram Assignment Help service, you will get the most authentic and flawless academic content every time.
Tags: Dependency Diagram Assignment Help, Dependency Diagram Homework Help, Dependency Diagram Coursework, Dependency Diagram Solved Assignments, Crow's Foot ERD Assignment Help, Crow's Foot ERD Homework Help, Crow's Foot ERD Coursework