Recent questions tagged goclasses-cs-dpp-day-47

Which of the following is aggregate function in SQL?AvgSelectOrdered bydistinct

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

Suppose R is a relation schema and F is a set of functional dependencies on R. Further, suppose R1 and R 2 form a decomposition of R . Then the decomposition is a lossles...

Which of the following is true?A relation in BCNF is always in $3NF$A relation in $3NF$ is always in BCNFBCNF and $3 N F$ are sameA relation in BCNF is not in $3NF$

Armstrong (1974) proposed systematic approach to derive functional dependencies. Match the following w.r.t functional dependencies:Codes:a-iii, b-ii, c-iv, d-i a-i, b-iii...