Bissoy.com
Doctors Medicines MCQs Q&A

A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.

A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z. Correct Answer Transitive Dependencies

Third Normal Form deals with something called ‘transitive’ dependencies. This means if we have a primary key A and a non-key domain B and C where C is more dependent on B than A and B is directly dependent on A, then C can be considered transitively dependent on 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?
Which of the following statements are true about dependency theory? (A) Dependency theory was strongly influenced by Marxists and Non-Leninists who were critical of Development theory (B) Dependency theory stressed the peaceful, evolutionary process of modernisation (C) Development in the third world was dependent on development in the already developed nations. (D) The First World does not exploit the third world Choose the most appropriate answer from the options given below:
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
Socrates says that
1. virtue is knowledge through concepts.
2. vice is ignorance.
3. virtue can be taught.
4. virtue is one.
Select the correct answer:
2x+3y3x+2y=56 হলে কোনটি xঃy ?
A functional dependency f on R is _______ by a set of functional dependencies F on r if every instance of r(R) that satisfies f also satisfies F.
Consider the following graphs. The curves in the graphs indicate different age groups in the populations of two countries A and B over a period of few decades: With reference to the above graphs, which of the following are the most logical and rotational inferences that can be made? 1. Over the last two and a half decades, the dependency ratio for country B has decreased. 2. By the end of the next two and a half decades, the dependency ratio of country A and be much less than that of country B. 3. In the next two decades, the work-force relative to its total population will increase in country B as compared to country A. Select the correct answer using the code given below.
Seven people A, B, C, D, E, F and G live on separate floors of a 7-floor building. Ground floor is numbered 1, first floor is numbered. 2 and so on until the topmost floor is numbered 7. Each one of these having a different cars-Cadillac, Ambassador, Fiat, Maruti, Mercedes, Bedford and Fargo but not necessarily in the same order. Only three people live above the floor on which A lives. Only one person lives between A and the one having a car Cadillac. F lives immediately below the one having a car Bedford. The one having a car Bedford lives on an even-numbered floor. Only three people live between the ones having a car Cadillac and Maruti. E lives immediately above C. E is not having a car Maruti. Only two people live between B and the one having a car Fargo. The one having a car Fargo lives below the floor on which B lives. The one having a car Fiat does not live immediately above D or immediately below B. D does not live immediately above or immediately below A. G does not have a car Ambassador. Question : How many people live between the floors on which D and the one having a car Bedford ?
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?
The following question is based on the given data for an examination. A. Candidates appeared 10500 B. Passed in all the five subjects 5685 C. Passed in three subjects only 1498 D. Passed in two subjects only 1250 E. Passed in one subject only 835 F. Failed in English only 78 G. Failed in Maths only 275 H. Failed in Physics only 149 I. Failed in Chemistry only 147 J. Failed in Biology only 221 How many candidates passed in at least four subjects ?