RelationalDBDesign  
prev next
  Course navigation
   
Functional Dependencies - Exercise
    Functional dependencies, part 2

Representing functional dependencies
Objective: Represent functional dependencies using proper notation.

Exercise scoring
This exercise is worth a total of 10 points. You’ll 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 OK, I’m Done to submit them to a tutor and view a results page.