Relation R with an associated set of functional dependencies, F is decomposed in to BCNF. The redundancy in the resulting set of relation is
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Relation R is decomposed using a set of functional dependencies F and relation S is decomposed using anothe...
- R, (A, B, C, D) is a relation. Which of the following does not have a lossless join, dependency preserving ...
- Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH $\rightarrow$ G, ...
- A relational database, which is in 3NF, may have undesirable data redundancy because there may exist
- Consider a schema R(A,B,C,D) and functional dependencies A$\rightarrow$ B and C$\rightarrow$ D. Then the de...
- Consider the schema R = (S, T, U, V) and dependencies S$\rightarrow$T, T$\rightarrow$U, U$\rightarrow$V and...
- If every non-key attribute is functionally dependent on the primary key, the relation will be in
- P : Foreign key cannot have a null value. Q : Primary key and foreign key can exist in same relation. R : F...