Match List I with List II
| List I | List II |
|---|---|
| (a) BCNF iff | (I) every JD is implied by the candidate keys |
| (b) 5NF iff | (II) all underlying domains contain scalar values only |
| (c) 1NF iff | (III) every MVD is implied by the candidate keys |
| (d) 4NF iff | (IV) every FD is implied by the candidate keys |
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 iff every FD is implied by the candidate keys (IV); 5NF iff every JD is implied by the candidate keys (I); 1NF iff all domains contain only scalar values (II); 4NF iff every MVD is implied by the candidate keys (III).More Database Management Systems questions
- Find the number of tuples obtained by applying the operation X ⟕X.S = Y.S Y (left outer join).
- The result of the operation X ⟖X.S = Y.S Y (right outer join) will be:
- Which join is used to get all the tuples of relations X and Y, with NULL values for the corresponding missing values?
- The number of tuples obtained by applying a right outer join on relations X and Y is:
- The number of tuples obtained by applying the Cartesian product over X and Y is:
- The total cost of retrieving records in sorted order using an unclustered B+ tree is (P = average number of records per data page, N = numb…