1 votes 1 votes Consider a relation R with five attributes ABCDE. You are given the following dependencies: A → B, BC → E, and ED → A. 1. List all keys for R. 2. Is R in 3NF? 3. Is R in BCNF? gabbar asked Oct 10, 2016 gabbar 18.8k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 6 votes 6 votes its a simple question Rajesh Raj answered Oct 10, 2016 • selected Oct 10, 2016 by gabbar Rajesh Raj comment Share Follow See 1 comment See all 1 1 comment reply gabbar commented Oct 10, 2016 reply Follow Share Thnx alot 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes 1.all the keys of R are:(3 keys) ACD+ ={ACDBE} BCD+ ={BCDEA} ECD+={ECDAB} 2. since in all the FD's , R.H.S is prime attribute hence R is in 3NF 3.R is not in BCNF, because L.H.S is not a key in the given FD's cse23 answered Oct 10, 2016 cse23 comment Share Follow See 1 comment See all 1 1 comment reply gabbar commented Oct 10, 2016 reply Follow Share thnq 0 votes 0 votes Please log in or register to add a comment.