Relation R with an associated set of functional dependencies, F is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations 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 ...
- A relational database, which is in 3NF, may have undesirable data redundancy because there may exist
- Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH $\rightarrow$ G, ...
- Consider a schema R(A,B,C,D) and functional dependencies A$\rightarrow$ B and C$\rightarrow$ D. Then the de...
- If a relation is in BCNF, it is also in
- P : Foreign key cannot have a null value. Q : Primary key and foreign key can exist in same relation. R : F...
- Which of the following functions is not directly related to a file?