RelationalDBDesign
RedhatLinuxSys Seomining
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 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.