Register

PW DPP DBMS Minimal/Canonical cover

682 views
1 1 vote
Consider the following FD set : { P -> QR, Q -> PR, R -> PQ}

Which of the following is/are the minimal cover for the above FD set?

 

A) P -> Q, Q -> R, R -> P

B) P -> R, Q -> R, R -> PQ

 C) Q -> P, P -> R, R -> Q

 D) P -> QR, Q -> P, R -> P

1 Answer

Voting & Accepting an answer helps improve the community
← Previous · Slotted AlohaNext → · i have a doubt in da...
← Previous in category · GO Classes DA Test S...Next in category → · GO Classes DA Test S...
Position:
Show:

Related questions

4 4 votes
2 2 answers
213
213 views
GO Classes asked Sep 9
213 views
GO Classes DPP | GATE CS, DA | DBMS | Minimal Cover
Consider $F=\{AB \to CF,\ CD \to EA,\ E \to ABC,\ B \to F,\ C \to D\}$Which of the following is a minimal cover of $F$?$\{AB \to C,\ C \to D,\ C \to E,\ E \to A,\ E \to B...
4 4 votes
1 1 answer
168
168 views
GO Classes asked Sep 9
168 views
GO Classes DPP | GATE CS, DA | DBMS | Minimal Cover
Consider $F=\{P \to S,\ PQ \to ST,\ S \to RU,\ RU \to S,\ PT \to V\}$.Which of the following is a minimal cover of $F$?$\{P \to S,\ PQ \to ST,\ S \to RU,\ RU \to S,\ PT \...
0 0 votes
1 1 answer
557
557 views
? asked Feb 21, 2025
557 views
PW DPP DBMS - BCNF Decomposition
Consider a relation R(ABCD) where {AB - CD, D - A}. Check for BCNF, and if found to be violating it's conditions, decompose and tell the candidate keys for each table.
3 3 votes
1 1 answer
247
247 views
GO Classes asked Sep 9
247 views
GO Classes DPP | GATE CS, DA | DBMS | FD Equivalence & Cover
Consider the two FD sets, $F=\{A \to B,\ B \to C,\ C \to A\}$ and $G=\{A \to C,\ C \to B,\ B \to A\}$.Which of the following statements is correct?Only $F$ is a minimal c...