Normalization

1NF, 2NF, 3NF, BCNF, functional dependencies.

Log in to read this chapter

This chapter is part of GATE Computer Science. Log in to continue reading the full lessons, notes and practice.

What you'll learn in this chapter

Functional dependencies
Functional Dependencies and Attribute Closure
Normal forms
First Second and Third Normal Forms
BCNF and Higher Normal Forms
Decomposition Lossless Join and Dependency Preservation