Civil Engineering (CE) Exam > Civil Engineering (CE) Questions > Consider a relational table R that is in 3NF,...
Start Learning for Free
Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?
- a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.
- b)R has a 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.
- c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.
- d)A cell in R holds a set instead of an atomic value.
Correct answer is option 'A'. Can you explain this answer?
| FREE This question is part of | Download PDF Attempt this Test |
Most Upvoted Answer
Consider a relational table R that is in 3NF, but not in BCNF, Which o...
B)R has a candidate key that is a proper subset of some other candidate key.
c)R has a transitive dependency that is not in BCNF.
d)R has a nontrivial functional dependency that is not in BCNF.
The correct answer is c) R has a transitive dependency that is not in BCNF.
3NF guarantees that there are no nontrivial transitive dependencies in the table, but it does not guarantee that there are no nontrivial functional dependencies. BCNF, on the other hand, guarantees that there are no nontrivial functional dependencies. So, if a table is in 3NF but not in BCNF, it must have a transitive dependency that is not in BCNF.
c)R has a transitive dependency that is not in BCNF.
d)R has a nontrivial functional dependency that is not in BCNF.
The correct answer is c) R has a transitive dependency that is not in BCNF.
3NF guarantees that there are no nontrivial transitive dependencies in the table, but it does not guarantee that there are no nontrivial functional dependencies. BCNF, on the other hand, guarantees that there are no nontrivial functional dependencies. So, if a table is in 3NF but not in BCNF, it must have a transitive dependency that is not in BCNF.
Free Test
FREE
| Start Free Test |
Community Answer
Consider a relational table R that is in 3NF, but not in BCNF, Which o...
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.
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 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.
Attention Civil Engineering (CE) Students!
To make sure you are not studying endlessly, EduRev has designed Civil Engineering (CE) study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Civil Engineering (CE).
|
Explore Courses for Civil Engineering (CE) exam
|
|
Similar Civil Engineering (CE) Doubts
Top Courses for Civil Engineering (CE)View all
Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer?
Question Description
Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? for Civil Engineering (CE) 2024 is part of Civil Engineering (CE) preparation. The Question and answers have been prepared according to the Civil Engineering (CE) exam syllabus. Information about Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? covers all topics & solutions for Civil Engineering (CE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer?.
Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? for Civil Engineering (CE) 2024 is part of Civil Engineering (CE) preparation. The Question and answers have been prepared according to the Civil Engineering (CE) exam syllabus. Information about Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? covers all topics & solutions for Civil Engineering (CE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer?.
Solutions for Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? in English & in Hindi are available as part of our courses for Civil Engineering (CE).
Download more important topics, notes, lectures and mock test series for Civil Engineering (CE) Exam by signing up for free.
Here you can find the meaning of Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of
Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer?, a detailed solution for Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? has been provided alongside types of Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? theory, EduRev gives you an
ample number of questions to practice Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?a)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a prime attribute.b)R has a 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.c)R has a nontrivial functional dependency X → A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.d)A cell in R holds a set instead of an atomic value.Correct answer is option 'A'. Can you explain this answer? tests, examples and also practice Civil Engineering (CE) tests.
|
|
Explore Courses for Civil Engineering (CE) exam
|
|
Suggested Free Tests
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
|
© EduRev
|
Education Revolution
|
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup