Database Systems: Concepts, Design and Applications

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 ...