- 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 16 times
1. Consider the relation with schema R(A, B, C, D), and the following set of functional dependencies: F = { A+D ; B,C →
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
1. Consider the relation with schema R(A, B, C, D), and the following set of functional dependencies: F = { A+D ; B,C →
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.