Recent questions tagged functional-dependency

Consider the following FD Set: (PQR, QPR, R→ PQ) which of the following is/are the minimal cover for the above FD set? [MSQ] A. PQQR, R→ P B. PR, QR, R→ PQ C. QP, PR...

​​Consider a database relation $\text{R}$ with attributes $\text{ABCDEFG}$, and having the following functional dependencies:\[\mathrm{A} \rightarrow \mathrm{BCEF} \quad ...

Consider a relational schema team $\text{(name,city,owner)}$, with functional dependencies $\{\text{name} \rightarrow \text{city}, \text{name} \rightarrow \text{owner} \}...

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.

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 - PB) P - R, Q - R, R - ...