RelationalDBDesign 




Database Analysis   «Prev  Next»
Functional Dependencies - Exercise
Representing functional dependencies
Objective: Represent functional dependencies using proper notation.
Exercise scoring
This exercise is worth a total of 10 points.
You will receive up to five points for correctly identifying each functional dependency in the given relations.
Instructions
Identify the functional dependencies in the following relations and represent the dependencies using the proper notation.
  1. Book (BookID, Title, Publisher, Year, ISBN)
    
  2. Computer (CompID, CPU, Memory, HardDrive, Floppy, Monitor)
    
Submitting your exercise
Type or paste the normalized relations into the text box below, then click Submit to submit them and view a results page.