Page 1 of 1
1. Consider the relation with schema R(A, B, C, D), and the following set of functional dependencies: F = { A+D ; B,C →
Posted: Fri May 20, 2022 4:37 pm
by answerhappygod
- 1 Consider The Relation With Schema R A B C D And The Following Set Of Functional Dependencies F A D B C 1 (30.83 KiB) Viewed 17 times
1. Consider the relation with schema R(A, B, C, D), and the following set of functional dependencies: F = { A+D ; B,C → A;D → A,B }. a. For each of the fifteen non-empty subsets S of the set of attributes {A, B, C, D, find the closure of S using the set of functional dependencies F. b. List all of the superkeys of R. c. List all of the candidate keys of R. d. Is R in BCNF? Explain why or why not. e. Is R in 3NF? Explain why or why not.