Functional Dependency
Example
Functional Dependency (meaning)
FD is a property of a Relation
FD is a property of a Relation
Other Properties of FDs
Normal Forms based of PK’s
FD is a generalization of a Key
First Normal Form (1NF)
Second Normal Form (2NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Third Normal Form (3NF)
602.48K
Category: programmingprogramming

Analysis and Design of Data Systems. Functional Dependencies and Normalization Theory (Lecture 15)

1.

IE301
Analysis and Design of Data Systems
Lecture 15
Functional Dependencies and
Normalization Theory
Aram Keryan
November 2, 2015

2. Functional Dependency

Let’s think of the whole database as being described by a single
universal relation schema
English     Русский Rules