O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Fill in the Blanks

1.Normalization is a process of ________ a set of relations with anomalies to produce smaller and well-structured relations that contain minimum or no ________.
2.________ is the formal process for deciding which attributes should be grouped together.
3.In the ________ process we analyse and decompose the complex relations and transform them into smaller, simpler, and well-structured relations.
4.________ first developed the process of normalization.
5.A relation is said to be in 1NF if the values in the domain of each attribute of the relation are ________.
6.A relation R is said to be in 2NF if it is in ________ and every non-prime key attributes of R is ________ on each relation key of R.
7.2NF can be violated only when ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required