Bissoy.com
Doctors Medicines MCQs Q&A

Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?

Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE? Correct Answer R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.

Concept:

A relation is in 1NF if every values in the relation are atomic.

A relation R with nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is not a proper subset of any key is in called to be in 2NF.

A relation R with nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute, is called to be in 3NF.

A relation R with nontrivial functional dependency X → A, where X is a superkey is called to be in BCNF.

Explanation:

Statement I:

corresponds to a relation that is in 3NF but not in BCNF, because for BCNF, X must be a superkey.

Statement II

corresponds to a relation that is only in 2NF by definition.

Statement III

corresponds to a relation that is not even in 2NF. It is in 1NF.

Statement IV corresponds to a relation that is not even in 1NF.

Related Questions

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?
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?
Given the following two statements: S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF. S2: AB → C, D → E, E → C is a minimal cover for the set of functional dependencies AB → C, D → E, AB → E, E → C. Which one of the following is CORRECT?
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?
A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
Read the given seating arrangement information and answer the question that follows. Prashant, Kamal, Rishi, Sunita, Tanvi, Vimal, Wazir and Yogita are sitting at a square table in such a way that four of them are sitting at four corners of the table, while the other four are sitting in the middle of each of four sides of the table. The four who are sitting at the corners of the table are facing the centre, whereas those who are sitting in the middle of the sides of the table are facing outside. Prashant, who is facing the centre, is sitting third to the right of Vimal. Tanvi, who is facing the centre, is not an immediate neighbour of Vimal. Only one person is sitting between Vimal and Wazir. Sunita sits second to the right of Kamal. Kamal is facing the centre. Rishi is not an immediate neighbour of Prashant. Which of the following statements regarding Kamal is true?
Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation. Employee (empId, empName, empAge) Dependent(depId, eId, depName, depAge) Consider the following relational algebra query: ΠempId(employee)-ΠempId (employee⋈(empId = eID)∧(empAge ≤ depAge)dependent) The above query evaluates to the set of empIds of employees whose age is greater than that of
Given below are two statements. One is labelled as Assertion (A) and the other is labelled as Reason (R).  Assertion (A): Tax should not be charged on dividend income from the shareholders  Reason (R): Some economists are of the opinion that when tax has already been paid on the profit of the company and balance is distributed as dividend to the owners, tax need not be levied on them  In the light of the above two statements, choose the correct answer from the options given below  1. Both A) and R) true and R) is the correct explanation of A) 2. Both A) and R) true but R) is NOT the correct explanation of A) 3. A) is true but R) is false  4. A) is false but R) is true
P, Q, R, S, T, W, Y and Z are sitting around a circular table from equal distances to each other and facing towards centre. They all like different colours viz., Red, Blue, Green, Black, White, Pink, Yellow and Brown (not necessarily in the same order). P likes yellow and sitting third to the left of W. Two persons are sitting between W and S. The one who likes pink is not sitting with P nor with W. Only one person is sitting between T and Z but not P and S. Y likes black but he is not sitting with S. R does not like pink nor white. T is sitting to the immediate left one who likes green. Z does not like brown nor he is sitting to the immediate right one who likes black. The one who likes white is not sitting with W. R neither likes brown nor Red. Which of the following combination is true as per the given information?