Bissoy.com
Doctors Medicines MCQs Q&A

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

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 Correct Answer More than zero but less than that of an equivalent 3NF decomposition

Redundancy in BCNF is low when compared to 3NF. For more details on BCNF.

Related Questions

Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respective primary keys. Schema I: Field ‘courses’ is a set-valued attribute containing the set of courses a student has registered for. Non-trivial functional dependency: rollno → courses Schema II: Non-trivial functional dependencies: rollno, courseid → email email → rollno Schema III: Non-trivial functional dependencies: rollno, courseid → marks, grade marks → grade Schema IV: Non-trivial functional dependencies: rollno, courseid → credit courseid → credit Which one of the relational schemas above is in 3NF but not in BCNF?
Let the set of functional dependencies F = {QR → S, R → P, S → Q} hold on a relation schema X = (PQRS). X is not in BCNF. Suppose X is decomposed into two schemas Y and Z, where Y = (PR) and Z = (QRS). Consider the two statements given below. I. Both Y and Z are in BCNF II. Decomposition of X into Y and Z is dependency preserving and lossless Which of the above statements is/are correct?
Consider the following statements regarding database normal forms: 1. Any relation with two attributes is BCNF. 2. Lossless, dependency - preserving decomposition into BCNF is always possible. 3. Lossless, dependency - preserving decomposition into 3NF is always possible. 4. BCNF is stricter than 3NF. Which of the above statements are correct?
An Identity Card has the number ABCDEFG, not necessarily in that order, where each letter represents a distinct digit (1, 2, 4, 5, 7, 8, 9 only). The number is divisible by 9. After deleting the first digit from the right, the resulting number is divisible by 6. After deleting two digits from the right of original number, the resulting number is divisible by 5. After deleting three digits from the right of original number, the resulting number is divisible by 4. After deleting four digits from the right of original number, the resulting number is divisible by 3. After deleting five digits from the right of original number, the resulting number is divisible by 2. Which of the following is a possible value for the sum of the middle three digits of the number?
Facts related to public relations are given below
1. Internal relations
2. Customer relations
3. Concept of public relations
4. Internal coordination
Which of the above given is/are types of public relations?
The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies
Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies. PQ → X; P → YX; Q → Y; Y → ZW Consider the decomposition of the relation R into the constituent relations according to the following two decomposition schemes. D1 : R = [(P, Q, S, T); (P, T, X); (Q, Y); (Y, Z, W)] D2 : R = [(P, Q, S); (T, X); (Q, Y); (Y, Z, W)] Which one of the following options is correct?
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out of the four alternatives.
The nation has been _____as a relatively extensive, territorial relation of nativity. We have further formulated the_____of the nation as a territorially_____, yet bounded, social relation for the generation, transmission, and ____of life. When the nation is a national state, it is also a_____for the protection of life. The nation is often ______by the metaphor of familial relations and, indeed, has sometimes been considered as some kind of_____family. This is understandable because both the nation and the family are relations of_____. Nonetheless, there is an important difference, and to understand this will _____a more detailed examination of the_____ between territory and bonding.
The nation is often_______by the metaphor of familial relations
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out of the four alternatives.
The nation has been _____as a relatively extensive, territorial relation of nativity. We have further formulated the_____of the nation as a territorially_____, yet bounded, social relation for the generation, transmission, and ____of life. When the nation is a national state, it is also a_____for the protection of life. The nation is often ______by the metaphor of familial relations and, indeed, has sometimes been considered as some kind of_____family. This is understandable because both the nation and the family are relations of_____. Nonetheless, there is an important difference, and to understand this will _____a more detailed examination of the_____ between territory and bonding.
This is understandable because both the nation and the family are social relations of________.
The following functional dependencies hold true for the relational schema R{V, W, X, Y, Z}: V → W VW → X Y → VX Y → Z Which of the following is irreducible equivalent for this set of functional dependencies?