Register

UGC NET CSE | December 2014 | Part 3 | Question: 10

• recategorized by
2,703 views
4 votes
4 votes

Let $R = ABCDE$ is a relational scheme with functional dependency set $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$. The attribute closures of $A$ and $E$ are 

  1. $ABCD, \phi$
  2. $ABCD, E$ 
  3. $\Phi, \phi$ 
  4. $ABC, E$ 
• recategorized by
User Avatar

2 Answers

Best answer
12 votes
12 votes

{A}+={ A , B , C , D }

{E}+={E}

Hence,Option(B) ABCD , E.

• selected by
User Avatar
2 votes
2 votes

Closure(A)=ABCD

Closure(E)=E

Therefore option B will be right option for it.

User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

6 votes
6 votes
2 answers
1
makhdoom ghaya asked Jul 25, 2016
5,250 views
UGC NET CSE | December 2014 | Part 3 | Question: 12
Which of the following is false ? Every binary relation is never be in $BCNF$. Every $BCNF$ relation is in $3NF$. $1 NF, 2 NF, 3 NF$ and $BCNF$ are based on functional dependencies. Multivalued Dependency $(MVD)$ is a special case of Join Dependency $(JD)$
Which of the following is false ? Every binary relation is never be in $BCNF$. Every $BCNF$ relation is in $3NF$. $1 NF, 2 NF, 3 NF$ and $BCNF$ are based on functional de...
User Avatar
2 votes
2 votes
2 answers
2
makhdoom ghaya asked Jul 28, 2016
3,318 views
UGC NET CSE | December 2014 | Part 3 | Question: 38
How to express that some person keeps animals as pets?
How to express that some person keeps animals as pets?
User Avatar
2 votes
2 votes
1 answer
3
makhdoom ghaya asked Jul 24, 2016
3,175 views
UGC NET CSE | December 2014 | Part 3 | Question: 09
_________ rules used to limit the volume of log information that has to be handled and processed in the event of system failure involving the loss of volatile information. Write-ahead log Check-pointing Log buffer Thomas
_________ rules used to limit the volume of log information that has to be handled and processed in the event of system failure involving the loss of volatile information...
User Avatar
Link Copied!