Bissoy.com
Doctors Medicines MCQs Q&A

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?
The question below consists of a question and two statements. You have to decide whether the data provided in the statements are sufficient to answer the question and based on this give answer. Six arrows of different colours – Red, Green, Pink, Blue, White and Black are placed around a circular table facing the centre. Question: Which colour’s arrow is placed to the immediate left of black coloured arrow? Statements: I. Green coloured arrow is placed opposite to the white coloured arrow which is to the immediate left of pink coloured arrow. II. Red coloured arrow is placed opposite to blue coloured arrow and is placed adjacent to white coloured arrow.
For realizing a binary half-subtractor having two inputs A and B, the current set of logical expression for the outputs D (A minus B) and X (borrow) are 1. The difference output D = A̅B + AB̅ 2. The borrow output B = AB̅ Which of the above statements is/are correct? 
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
The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies
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?
If a + b + c + d = 4, then find the value of $$\frac{1}{{\left( {1 - a} \right)\left( {1 - b} \right)\left( {1 - c} \right)}}$$     + $$\frac{1}{{\left( {1 - b} \right)\left( {1 - c} \right)\left( {1 - d} \right)}}$$     + $$\frac{1}{{\left( {1 - c} \right)\left( {1 - d} \right)\left( {1 - a} \right)}}$$     + $$\frac{1}{{\left( {1 - d} \right)\left( {1 - a} \right)\left( {1 - b} \right)}}$$     is?
If a + b + c + d = 4, then the value of $$\frac{1}{{\left( {1 - a} \right)\left( {1 - b} \right)\left( {1 - c} \right)}}$$     + $$\frac{1}{{\left( {1 - b} \right)\left( {1 - c} \right)\left( {1 - d} \right)}}$$     + $$\frac{1}{{\left( {1 - c} \right)\left( {1 - d} \right)\left( {1 - a} \right)}}$$     + $$\frac{1}{{\left( {1 - d} \right)\left( {1 - a} \right)\left( {1 - b} \right)}}$$     is?
A _________ Fc for F is a set of dependencies such that F logically implies all dependencies in Fc, and Fc logically implies all dependencies in F.
A- Press DOWN ARROW or CTRL+DOWN ARROW , B- Press SHIFT+LEFT ARROW: 1- Move the selected control down, 2- Reduce the width of the selected control.