Register

GO Classes DPP | Databases | Functional dependency | JMU

663 views
2 2 votes

What is the highest normal form satisfied by the relation $R(A, B, C, D, E)$ with functional dependencies $\mathbf{C E} \rightarrow$ $\mathbf{D}, \mathbf{D} \rightarrow \mathbf{B}, \mathbf{C} \rightarrow \mathbf{A}$, assuming no multivalued dependencies?

  1. $1$ NF
  2. $2$ NF
  3. $3$ NF
  4. BCNF

5 Answers

2 2 votes
There is a partial dependency $\mathbf{C} \rightarrow \mathbf{A}$, where $\mathbf{C}$ is part of the candidate key $\mathbf{C E}$, and $\mathbf{A}$ is a non-prime attribute.
So, the relation violates $\mathbf{2NF}.$
Therefore, the highest normal form is $\mathbf{1NF}$.
• reshown by
2 2 votes

(CE) is the candidate key 

A , B , D are non prime attributes 

Not in 2NF because,  C ➡ A  (violation: "proper subset of a candidate key determines non prime attribute")

Not in 3NF because , D➡ B (violattion:"not a super key determines non prime attribute") 

And also not in BCNF.

Therefore, highest normal form = 1 NF (A)

0 0 votes

Answer : The given Relation is in 1NF. Option - A

C.K = CE 

Proper Subset of C.K , C determines A ( that is Non prime Attribute ),so this is the violation of 2NF . So Do not need to check upper Normal Form. 

Voting & Accepting an answer helps improve the community
Answer:
← Previous · GO Classes | DA Cour...Next → · GO Classes DPP | Dat...
← Previous in category · Indexing DBMSNext in category → · GO Classes DPP | Dat...
Position:
Show:

Related questions

3 3 votes
6 6 answers
709
709 views
GO Classes asked Jul 11, 2025
709 views
GO Classes DPP | Databases | Functional dependency | JMU
Consider a relation $\mathbf{R(A, B, C, D, E)}$ with the functional dependencies:$$\mathbf{CE} \rightarrow \mathbf{D}, \mathbf{D} \rightarrow \mathbf{~B}, \mathbf{C} \rig...
4 4 votes
6 6 answers
765
765 views
GO Classes asked Jul 11, 2025
765 views
GO Classes DPP | Databases | Functional dependency | ISRO
Armstrong's inference rule doesnot determineReflexivityAugmentationTransitivityMutual dependency
1 1 vote
6 6 answers
687
687 views
GO Classes asked Jul 11, 2025
687 views
GO Classes DPP | Databases | Functional dependency | ISRO
Let $x, y, z, a, b, c$ be the attributes of an entity set E . If $\{x\},\{x, y\},\{a, b\},\{a, b, c\},\{x, y, z\}$ are superkeys then which of the following are the candi...
5 5 votes
3 3 answers
516
516 views
GO Classes asked Jul 20, 2025
516 views
GO Classes DPP | Databases | Functional dependency | JMU
Consider a relation R(A, B, C, D, E, F, G, H, I, J) with functional dependencies:$$\mathrm{AB} \rightarrow \mathrm{C}, \mathrm{BD} \rightarrow \mathrm{EF}, \mathrm{AD} \r...