Question: Suppose that you have been given the table structure and

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.
View Solution:


Sale on SolutionInn
Sales3
Views288
Comments
  • CreatedDecember 03, 2014
  • Files Included
Post your question
5000