Recent questions tagged goclasses-da-dpp

Consider $R(A,B,C,D,E,F,G,H)$ with $F=\{AB\to CD,\ AC\to DE,\ EF\to AG\}$.The decomposition is $R_1(A,C,D,E),$ $R_2(A,B,C),$ $R_3(A,B,F,G,H)$.Which statement correctly de...

Consider $R(A,B,C,D,E,F,G)$ with $F=\{AC\to BD,\ BC\to E,\ BE\to DF,\ AG\to EB\}$ and decomposition $R_1(A,B,C,D),$ $R_2(A,B,C,E,G),$ $R_3(B,E,F),$ $R_4(A,E,G)$.Which of ...

Consider $R(A,B,C,D,E,F)$ with $F=\{A\to C,\ CE\to D,\ CD\to A,\ DF\to A\}$.The decomposition is $R_1(A,B,C,D),$ $R_2(A,D,E),$ $R_3(B,C,E,F)$.Which statement is correct?T...

Consider the relation $R(T,I,G,E,R,S)$ with $F=\{G\to ES,\ RT\to I,\ IR\to E\}$.It is decomposed into $R_1(T,E),$ $R_2(I,G),$ $R_3(I,E,R,S)$.What does the Chase Test conc...

Consider $R(S,N,C,P,X,Y,Q)$ with $F=\{S\to NC,\ P\to XY,\ SP\to Q\}$.The relation is decomposed into $R_1(S,N,C),$ $R_2(P,X,Y), $ $R_3(S,P,Q)$.Which statement is correct?...

Consider $R(A,B,C,D,E)$ with $F=\{A\to DE,\ BE\to C,\ D\to B,\ C\to A\}$.The relation is decomposed into $R_1(A,B,C)$ and $R_2(A,D,E)$.Which of the following statements a...

Consider $R(A,B,C,D,E,F)$ with $F=\{C\to D,\ A\to B,\ B\to EF,\ F\to A\}$.Suppose $R$ is decomposed into $R_1(A,B,D,E)$ and $R_2(A,B,C,F)$. The decomposition is currently...

Consider the binary decomposition$R(A,B,C,D)\to R_1(A,C,D),R_2(B,C)$.Which of the following statements are correct?If $C$ is a candidate key for $R_1$, the decomposition ...

Consider $R(A,B,C,D)$ with $F=\{B\to C,\ D\to A\}$.The relation is decomposed into $R_1(B,C)$ and $R_2(A,D)$.Which of the following statements are correct?The decompositi...

Consider $X(A,B,C,D,E,F)$ with $F=\{AB\to CD,\ CD\to EF\}$.The relation is decomposed into $X_1(A,B,C,D)$ and $X_2(C,D,E,F)$.Which statement is correct?The decomposition ...

Consider relation $R(A,B,C,D,E,F)$ with$A\to B$$A\to C$$F\to D$$F\to E$Suppose $R$ is decomposed into $R_1(A,B,C)$ and $R_2(D,E,F)$.Which statement best describes this de...

A redundant relation is decomposed appropriately to improve its logical database design.Which of the following benefits can be relied upon as a purpose of the decompositi...

Consider the single relation containing $\text{Course, Teacher, Room, Hour, StudentID, Grade}$.\[\begin{array}{|c|c|c|c|c|c|}\hline\text{Course} & \text{Teacher} & \text{...

A relation contains four tuples for course $\text{CS 186}$, and every tuple stores the teacher as $\text{Hellerstein}$.Lets consider the set of data is as follows :\[\beg...

Consider $\text{Postings(post, position, user, ptext)}$.Two aliases of this relation are used:$\text{P1 = Postings}$$\text{P2 = Postings}$Consider the query:SELECT count(...

Consider $R(A,B,C,D,E,F)$ with functional dependencies$A \to BCDEF$ $BC \to ADEF$ $E \to F$ $EF \to C$Which functional dependency satisfies 3NF but violates BCNF?$A \to B...

Consider $R(A,B,C,D)$ with $F=\{AB \to C,\ BC \to D,\ CD \to A,\ AD \to B,\ C \to BD\}$.Which of the following statements are correct?$C$ is a candidate key. $D$ is a can...

Consider the relation $R(B,T,S,P,D,C,H,A,R)$ with functional dependencies$R \to SP$$SP \to DCH$$B \to SCT$$DH \to A$$TS \to R$$SPR \to B$$S \to P$Which of the following F...

Consider $R(A,B,C,D)$ with functional dependencies$A \to BCD$$B \to C$$CD \to A$Assuming atomic values, what is the highest normal form satisfied by $R$?$\text{1NF}$ $\te...

Which of the following statements are always true?For any attribute set $X$, $(X^+)^+=X^+$. Every relation schema having exactly two attributes is in BCNF. If $AB \to C$ ...

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