Relational Theory

This website is not a complete guide to Relational Theory.

The Relational Model

Functional Dependencies

• Functional Dependencies (FDs)
• FD Inference Rules
• Minimal FD Lists
• Closure of a Set of FDs
• Consistent or Inconsistent FDs
• Semantically Obvious FDs

Relational Keys

• Superkeys
• Candidate Keys
  • Carol's Recipe for Finding Candidate Keys
  • Finding Candidate Keys Using FDs
  • Finding Candidate Keys When We Don't Have Any FDs to Use
• Primary Keys
• Alternate Keys

• Foreign Keys

Normal Forms

• Normal Forms
• Highest Normal Form

[Top]