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 ... |
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.