Recent questions tagged database-normalization

In the context of schema normalization in relational DBMS, consider a set $\text{F}$ of functional dependencies. The set of all functional dependencies implied by $\text{...

In the context of relational database normalization, which of the following statements is/are true?It is always possible to obtain a dependency-preserving $3$NF decomposi...

Can a super key contain NULL values?If yes, please explain why it is allowed.If not, please explain why NULL values are not permitted in a super key.Also, can a candidate...

2nf decomposition remove all partial dependencies.3Nf decomposition remove all transitive dependencies. are these statements correct?

Which of the following/s is/are $\mathrm{FALSE}$ statement?An all key relation is always in $\mathrm{BCNF}$ since it has no $\mathrm{FDs}.$A relation that is not in $4\ma...

Fifth normal form is concerned with:Join DependencyDomain-KeyMultivalued dependencyFunctional dependency

Consider a schema $\text{R(P, Q, R, S)}$ and the following functional dependencies $\text{P} \rightarrow \text{Q}, \text{Q} \rightarrow \text{R}, \text{R} \rightarrow \te...

In a schema $R(A, B, C, D, E, F, G, H)$, each field of $R$ contains only atomic values. $\mathrm{F}=\{\mathrm{CH} \rightarrow \mathrm{G}, \mathrm{A} \rightarrow \mathrm{B...

Match $\text{List - I}$ with $\text{List - II}$.$$\begin{array}{llll}& \text{List - I} & & \text{List - II} \\\text{(A)} & \text{BCNF iff} & \text{(I)} & \text{every JD i...

Consider a relational table $ R $ that is in $ 3NF $ but not in $ BCNF $ . Which one of the following statements is TRUE?A.$ R $ has a nontrivial functional dependency $...

Which of the following statements is true for a relation in $3$rd Normal Form $\text{(3NF)}?$It is in $2$nd Normal Form $\text{(2NF)}$It does not contain transitive depen...