1 votes 1 votes An organization needs to maintain database having five attributes $\textbf{A, B, C, D, E}$. These attributes are functionally dependent on each other for which functionality dependency set $F$ is given as: $\textbf{F}: \{ \textbf{A} \rightarrow \textbf{BC}, \textbf{D} \rightarrow \textbf{E}, \textbf{BC} \rightarrow \textbf{D}, \textbf{A} \rightarrow \textbf{D} \}$. Consider a universal relation $\textbf{R(A, B, C, D, E)}$ with functional dependency set $\textbf{F}$. Also all attributes are simple and take atomic values only. Identify primary key of table $R$ with functional dependency set $F$ $\textbf{BC}$ $\textbf{AD}$ $\textbf{A}$ $\textbf{AB}$ Others ugcnetcse-dec2019-paper2 + – soujanyareddy13 asked May 12, 2021 • edited May 25, 2021 by soujanyareddy13 soujanyareddy13 341 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes closure of A={A,B,C,D,E} Hence A is the primary key of table R. closure of BC={B,C,D,E} closure of AD={A,B,C,D,E} closure of AB={A,B,C,D,E} primary key is minimal superkey so,A is the primary key chirudeepnamini answered May 15, 2021 chirudeepnamini comment Share Follow See all 0 reply Please log in or register to add a comment.