Recent questions tagged attribute-closure

2 2 votes
1 1 answer
176
176 views
Consider the relation schema $R(A,B,C,E,F,G,H)$ with $F=\{A \to BC,\ C \to FG,\ E \to HG,\ G \to A\}$Which of the following statements are correct?$A^+=\{A,B,C,F,G\}$ $A ...
3 3 votes
1 1 answer
127
127 views
Consider the relation$Student(S,I,E,N,L)$with the functional dependencies$F=\{S \to I,\ I \to E,\ E \to S,\ N \to L\}$Which of the following are candidate keys?$SN$ $IN$ ...
2 2 votes
1 1 answer
152
152 views
Consider the relation schema $R(A,B,C,D,E,F)$ with$F=\{BE \to C,\ B \to F,\ D \to F,\ AEF \to B,\ A \to E\}$Which of the following is a candidate key of $R$?$ACD$ $AD$ $F...
To see more, click for the full list of questions or popular tags.