1 votes 1 votes can a table be in 3rd normal form without being in 2nd normal form!! Ankit Sharma 1 asked Jul 7, 2017 Ankit Sharma 1 401 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply Prashant. commented Jul 7, 2017 reply Follow Share No. ! 1 votes 1 votes joshi_nitish commented Jul 10, 2017 reply Follow Share no, it is not possible since for relation to be in 3NF, following condition to be satisfied if A->a.... then either 'A' is superkey or 'a' is prime attribute, now if table will not be in 2NF then there exist a partial dependency(A->B) such that neither A will be superkey nor B will be prime attribute, hence it cant be in 3NF. 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes No its not possible. By Definition, we say that If a Relation is in 3NF , it must be in 2NF and there is no transitive dependency between any non prime attribute and candidate key. Source: https://en.wikipedia.org/wiki/Third_normal_form You can go thorough any standard test book, you will get better understanding. Arnab Bhadra answered Jul 7, 2017 Arnab Bhadra comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes we know that a relation to be in 3rd NF all fds must follow following rules.... 1.left of fd should be super key or 2.right of fd should be a prime attributes... if any of above is followed then definite there is no partial dependency.... hs_yadav answered Jul 7, 2017 hs_yadav comment Share Follow See all 0 reply Please log in or register to add a comment.
