1 votes 1 votes AB---->B AC---->C C------>B Highiest normal form? Gunvantwavhal asked Oct 12, 2017 Gunvantwavhal 399 views answer comment Share Follow See all 4 Comments See all 4 4 Comments reply Hemant Parihar commented Oct 13, 2017 reply Follow Share It is in 1NF, not in 2NF. AC is a candidate key, it can determine all A, B, and C. The non-prime attribute will be B. Which can be determined by the subset of the candidate key. C $\rightarrow$ B Not in 2NF. 1 votes 1 votes Shubhanshu commented Oct 13, 2017 reply Follow Share @Hemant Parihar which form it is:- {Prime, Non Prime} -> Non Prime. Like, AB---->B I think it should be 1NF. ryt?? 0 votes 0 votes Hemant Parihar commented Oct 13, 2017 reply Follow Share @Shubhanshu If this is the only functional dependency then it is BCNF. AB -> B (trivial). 0 votes 0 votes Gunvantwavhal commented Oct 13, 2017 reply Follow Share This is trival fd but my point of u it should be in1 nf... Bacause if we minimize the fd it remain same... 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes my answer Hira Thakur answered Oct 18, 2017 Hira Thakur comment Share Follow See all 0 reply Please log in or register to add a comment.