Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Normalization
| Question 63 |
Which of the following statements is NOT true with respect to database normalization?
| A 4NF is more immune against logical inconsistencies than a 3NF table. | |
| A 3NF table will have fewer anomalies than a 2NF table | |
| A 3NF table is more vulnerable than a 2NF table | |
| A database is said to be in 3NF if all its tables are in 3NF |
Question 63 Explanation:
→ A relation R is in 4NF if and only if the following conditions are satisfied:
1. It should be in the Boyce-Codd Normal Form (BCNF).
2. The table should not have any Multi-valued Dependency.
1. It should be in the Boyce-Codd Normal Form (BCNF).
2. The table should not have any Multi-valued Dependency.
Correct Answer: A
Question 63 Explanation:
→ A relation R is in 4NF if and only if the following conditions are satisfied:
1. It should be in the Boyce-Codd Normal Form (BCNF).
2. The table should not have any Multi-valued Dependency.
1. It should be in the Boyce-Codd Normal Form (BCNF).
2. The table should not have any Multi-valued Dependency.