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.


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.