Word Count : 647

---

We are given: Relation Schema: $R(A, B, C, D, E)$ Functional Dependencies (FDs): 1. $A \rightarrow BC$ 2. $CD \rightarrow E$ 3. $B \rightarrow D$ 4. $E \rightarrow A$ We are to compute $F^+$ (closure of F) and list candidate keys. --- ### Step 1: Compute the attribute closures to find candidate keys The candidate key is an attribute set whose closure gives all attributes $\{A, B, C, D, E\}$. Let’s check single attribute closures first: --- #### (i) $A^+$ Start with $\{A\}$: 1. $A \rightarrow BC$ ⇒ $\{A, B, C\}$ 2. $B \rightarrow D$ ⇒ $\{A, B, C, D\}$ 3. $CD \rightarrow E$ ⇒ $\{A, B, __________ ______ __________ __________ _____.
____ ________ ____ _________ ____ _______ ___ _______ ____.
__________ ________ ____ _________ ________ _____ ______.
__________ _________ ________ ____ ______ _________ ______ _________ ____.
_____ ________ ________ ________ ______ ___ _____.
________ _____ _________ ________ _________ ____ ______.
_________ ______ _____ ___ _______ _________ ______.
______ ___ ___ ________ ______ ______ ____.
__________ ______ ________ ________ ____ _____ _________ ___ ________ __________ _____ _________.
_______ ____ _____ ______ ________ _____ _________ ________.
____ ______ ______ ________ ___.
___ ________ _______ ________ ______.
__________ ________ _____ _________ _______ __________ ________.
___ _________ _______ _____ _______.
_________ ____ ___ ___ _____ _____ ___ __________ ______.
__________ ___ ___ ____ _______ ______ ______ ______ _________ ___.
___ ___ _____ ____ __________ ____ _____ ______.
_________ _____ _______ ________ ____ ____ _________ ___ _______.
_______ _______ ____ _______ ______ _______ _________ _______ _______ ______ __________.
___ __________ _______ _________ __________.
________ ________ ___ __________ ________.
__________ _________ ____ __________ ____ ________ _________ _____.
____ ________ _____ _________ _____ ______ _________ ____ ______.
__________ _______ __________ __________ ________ ____ _________.
_____ ______ _______ ___ ______ _______ __________ ___ __________ __________.
__________ _____ ______ ________ _____ _______ ______ _____ _______.
________ ______ ___ __________ ____ ________ ______ ____ ________ _____.
___ _______ _________ ______ _________ ________ __________ __________ ____ _____ __________ ___.
___ __________ _____ ___ _________ ________.
_________ _________ ________ _________ ___ ____ ______ ______.
_____ ___ _______ ____ _________ _________.
__________ ____ _____ ________ ________ ________ ___ _________.
____ ________ _________ ____ ______ ___ ______ __________.
_______ ________ __________ __________ ________ _____ ________ __________.
_________ _____ ______ _________ __________ ________ _____ _______ ______ _________ _____.
__________ ______ __________ _________ ____ ________.
___ ______ ________ __________ _________ ____ _____.
_____ _____ ___ ____ ______ __________ _________ ______ _________ _________.
_______ ______ ____ ______ ____ __________ _____ __________.
_________ ___ ________ ___ _____.
________ _____ ____ ____ ____ _________ _______.
_____ ____ __________ _________ _________ _________ ____ ____ ____ __________.
_______ _________ _________ _________ ____ ______ _________ _________ _____ _____.
____ ______ ________ ___ ______ ________.
______ ______ __________ ________ ____ _________ _____.
___ ______ _______ _______ ______ ________ ______ ______ ________ ___ _______.
____ __________ _______ ______ ________ ________ _______ _____ ___ _______ _______ _____.
_________ _______ __________ ________ ______ _______ _______ ____ ___.
____ ___ _________ ________ ___ ______ ______ ______ __________ ____.
__________ _______ ________ __________ _________ _______ __________.
______ ________ ____ ___ __________ _____ _______ _______ _________ ___ ________.
______ ___ _________ ________ ________.
______ ___ ____ ______ ______ _________ ______.
_______ ___ ____ ______ ___ ____ ________ ______.
________ __________ ________ ________ ________ __________ __________ _________ ______ ___.
_______ __________ ____ ______ _______ ________ ____.
____ ______ _______ _______ __________ __________ ___.
_________ __________ _____ ____ ______ __________ _______ __________ ____ ________ ____.
______ _____ _____ __________ __________ ______ _____ _____ ______ ____ ________ ______.
______ _______ ______ ________ __________ __________.
____ ____ _______ _____ _________ __________ __________ ______ ________ __________ ______.
____ ______ _____ _______ _________ ________ ________.
______ ________ _______ ___ _______ _________ _____ ___ _____ _______ ___.
_____ ________ __________ _________ _______.
_______ ________ _____ ___ __________ _______ _______ __________ _____ ___ ____.
______ _______ ______ ____ ____ _______ __________ ________.
_____.
Get Full Answer on WhatsApp