2 votes 2 votes Given a relation with five attributes and the following FDs: A -> D A -> E DE -> BC B -> A D -> C What is the highest normal form satisfied by the relation? Databases databases database-normalization + – Tuhin Dutta asked Jan 13, 2018 Tuhin Dutta 776 views answer comment Share Follow See all 9 Comments See all 9 9 Comments reply Show 6 previous comments srivivek95 commented Jan 13, 2018 reply Follow Share DE is minimal set of attribute. Can D or E alone be the candidate key? @ Mk Utkarsh 0 votes 0 votes sumit goyal 1 commented Jan 13, 2018 reply Follow Share Mk Utkarsh DE dont qualify minimal criteria if either D or E are minimal , then in that case DE becomes superkey not candidate key , then we say waha pe D ,E are candidate key not DE , HERE "DE " , A,B are all different so here we will not say A,B are minimal then DE will not be Candidte key , Watch youtube gate instructor video on candidate key then you will easily solve 1 votes 1 votes Mk Utkarsh commented Jan 13, 2018 reply Follow Share ohh thanks got it 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes D....>C is partial dependency. so it is in 1NF. abhishekmehta4u answered Mar 24, 2018 abhishekmehta4u comment Share Follow See all 0 reply Please log in or register to add a comment.