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