State True/False
1. | Normalization is a process of decomposing a set of relations with anomalies to produce smaller and well-structured relations that contain minimum or no redundancy. |
2. | A relation is said to be in 1NF if the values in the domain of each attribute of the relation are non-atomic. |
3. | 1NF contains no redundant information. |
4. | 2Nf is always in 1NF. |
5. | 2NF is the removal of the partial functional dependencies or redundant data. |
6. | When a relation R in 2NF with FDs A → B and B → CDEF (where A is the only candidate key), is decomposed into two relations R1 (with A → B) and R2 (with B → CDEF), the relations R1 and R2
|
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.