Match List - I with List - II.

Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. (a)-(IV), (b)-(I), (c)-(II), (d)-(III)
Explanation
BCNF: every FD is implied by the candidate keys. 5NF: every join dependency is implied by them. 1NF: all domains hold atomic (scalar) values. 4NF: every MVD is implied by the keys.
More Database Management Systems questions
- Find the number of tuples obtained by applying the right outer join X ⟖ (X.S = Y.S) Y.
- The result of the operation X ⟖ (X.S = Y.S) Y (right outer join) will be:
- Which of the following join is used to get all the tuples of relation X and Y with Null values of corresponding missing values?
- Number of tuples by applying right outer join on relation X and Y is/are :
- Let R(A, B, C, D) be a relational schema with dependencies A → B, B → C, C → D and D → B. The decomposition of R into (A, B), (B, C), (B, D…
- Which of the following scenario may lead to an irrecoverable error in a database system?