The questions can come in any order, so make sure you are selecting right option for all questions.
1. In 5NF, a relation cannot be further non-loss decomposed, meaning it cannot have any additional:
(c) Join dependencies
2. In 5NF, a relation is considered non-loss decomposed if:
(b) It cannot be decomposed into smaller relations without any loss of information.
3. In 5NF, a relation is said to be free from:
(d) All of the above
4. What is the primary goal of achieving 5NF in database normalization?
(a) To reduce redundancy and anomalies in data
5. Which of the following is true regarding a relation in 5NF?
(d) It is always fully normalized.
6. Consider the following table:
| Student | Subject | Lecturer | Semester |
|---|---|---|---|
| John | Computer | Anshika | Semester 1 |
| John | Math | John | Semester 1 |
| Akash | Math | John | Semester 2 |
| Praveen | Chemistry | Praveen | Semester 1 |
Which of the following options correctly describes the join dependency in this table?
(a) The table is not in 5NF because it has a join dependency between Student and Subject.
7. Which of the following normal forms is stricter than 5NF?
(d) BCNF
8. In the context of database normalization, what is the primary advantage of achieving 5NF over lower normal forms?
(c) Greater data integrity