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
Similar presentations:
Analysis and Design of Data Systems. General Definitions of 2NF & 3NF Boyce-Codd Normal Form (Lecture 16)
Analysis and Design of Data Systems. General Definitions of 2NF & 3NF Boyce-Codd Normal Form (Lecture 16)
Analysis and Design of Data Systems. Relational Algebra (Lecture 17)
Analysis and Design of Data Systems. Relational Algebra (Lecture 17)
Data. Structures in Python for Data analysis. lecture 2
Data. Structures in Python for Data analysis. lecture 2
Analysis and Design of Data Systems. Complex SQL Queries (Lecture 13)
Analysis and Design of Data Systems. Complex SQL Queries (Lecture 13)
Analysis and Design of Data Systems. Relational Algebra 2 (Lecture 18)
Analysis and Design of Data Systems. Relational Algebra 2 (Lecture 18)
Advances in Real-Time Rendering in Games
Advances in Real-Time Rendering in Games
OOP part2. Constructors
OOP part2. Constructors
Two-Level Logic Minimization Algorithms. Lecture 3
Two-Level Logic Minimization Algorithms. Lecture 3
Intro To AngularJS
Intro To AngularJS
Neural Networks
Neural Networks

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