Recent questions tagged normal-forms

Consider $R(A,B,C,D,E)$ with $A \to B,$ $BC \to E,$ and $ED \to A$.Which of the following statements are correct?$ACD$ is a candidate key. $BCD$ is a candidate key. $CDE$...

Consider $R(A,B,C,D,E,F)$ with $AC \to B,$ $BD \to F,$ and $F \to CE$.Which functional dependency causes $R$ to violate $\text{3NF}$?$AC \to B$ $BD \to F$ $F \to C$ $F \t...

Consider $R(A,B,C,D,E)$ with $C \to D,$ $DE \to B,$ and $AB \to C$.Which of the following statements are correct?$ABE$ is a candidate key. $ACE$ is a candidate key. $ADE$...

Consider $R(A,B,C,D,E)$ with $A \to B,$ $B \to C,$ $C \to D,$ and $C \to E$.Assuming atomic attribute values, what is the highest normal form satisfied by $R$?$\text{1NF}...

Consider $R(A,B,C,D)$ with functional dependencies $AB \to C,$ $BC \to D$.Which statement correctly explains why $R$ is not in $\textbf{3NF}$?$AB \to C$ violates $\text{3...

Consider the relation $R(A,B,C,D,E)$ with functional dependencies $AB \to C$, $E \to D$.Assume that no other non-trivial functional dependencies hold and that all attribu...

What is the name of the type of functional dependency that is removed when converting a relation from $\text{2NF}$ to $\text{3NF}$?Partial dependency Transitive dependenc...

Consider relation $\text{Exam(ExamId, Section, Date, Duration, AnswersDate, AnswersTime, RoomId, TimeFrom, RoomNo)}$ with primary key $\text{(ExamId, Section)}$ and the f...

Consider the relation $R(V,W,X,Y,Z)$ with functional dependencies :$V \to X$$WY \to X$$VWY \to Z$The candidate key is $VWY$.Assume that all attributes contain atomic valu...

Consider the relation $\text{course(c_id, dept_id, dept, evaluations, inst, office, sect, time_slot)}$with the following sample tuple:$\text{(61, 1, CS, {HW, Midterm, Fin...

Consider an $\text{ER}$ model with the entities $\text{E1}$ ( $\mathrm{A}_{11}, \mathrm{~A}_{12}, \mathrm{~A}_{13}$ ) and $\text{E2}$ ( $\mathrm{A}_{21}, \mathrm{~A}_{22}...

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

In a relational database, which one of the following is CORRECT:A relation with only two attributes is always in BCNF.If all attributes of a relation are prime attributes...

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...

Match the $\textbf{LIST-I}$ with $\textbf{LIST-II}$$\begin{array}{|l|l|c|l|} \hline & \textbf{ LIST-I } & & \textbf{ LIST-II } \\ \hline \text{A.} & \text{Project Join No...

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...

Which of the following relations can not be decomposed in to BCNF with a lossless join and dependency-preserving decomposition?$\mathrm{R}(\mathrm{V}, \mathrm{W}, \mathrm...

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...

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...

Which of the following is a characteristic of Boyce-Codd Normal Form $\text{(BCNF)}?$Every determinant is a candidate keyThere are no transitive dependenciesThere are no ...

Which normal form deals with removing partial dependencies?$1$st Normal Form $\text{(1NF)}$$2$nd Normal Form $\text{(2NF)}$$3$rd Normal Form $\text{(3NF)}$Boyce-Codd Norm...

Consider a relation with attributes (A, B, C, D} and the following functional dependencies:A → B, B → C and C → D. If A is the primary key, highest normal form ?

Q: What is the highest normal form of a relation R(A, B, C, D, E) with FD set?{B → A, A → C, BC → D, AC→ BE} Options:1. 2NF2. 3NF3. BCNF4. 4NF

Q) In R(A,B,C,D)FD's {AB->CD, C->D}Is it in 3NF?Ans) Vaise to shortcut (in x->y fd either x should be super key or y should be prime attribute to be in 3nf) ke hisaab se ...