Civil Engineering (CE) Exam > Civil Engineering (CE) Questions > Given the following two statements:S1: Every ...
Start Learning for Free
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?
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?
- a)S1 is TRUE and S2 is FALSE
- b)Both S1 and S2 are TRUE.
- c)S1 is FALSE and S2 is TRUE
- d)Both S1 and S2 are FALSE
Correct answer is option 'A'. Can you explain this answer?
| FREE This question is part of | Download PDF Attempt this Test |
Most Upvoted Answer
Given the following two statements:S1: Every table with two single-val...
Statement 1: TRUE
BCNF (Boyce Codd Normal Form):
A relation R is in BCNF whenever a non – trivial functional dependency X → A holds in R, where X is the super-key of R.
A binary relation is always in BCNF. A binary relation contains only two attributes.
Functional dependency that is possible from a binary relation is one.
BCNF (Boyce Codd Normal Form):
A relation R is in BCNF whenever a non – trivial functional dependency X → A holds in R, where X is the super-key of R.
A binary relation is always in BCNF. A binary relation contains only two attributes.
Functional dependency that is possible from a binary relation is one.
Example:
Consider R(A, B), in this only one functional dependency is possible either A → B or B → A
In both the cases, left hand side will be the super key. In this way R(A, B) is always in BCNF.
If a relation is in BCNF then it is in 1NF, 2 NF and 3 NF
Consider R(A, B), in this only one functional dependency is possible either A → B or B → A
In both the cases, left hand side will be the super key. In this way R(A, B) is always in BCNF.
If a relation is in BCNF then it is in 1NF, 2 NF and 3 NF
Statement 2: FALSE
Set 1 = {AB → C, D → E, AB → E, E→ C}
Set 2 = {AB → C, D → E, E → C}
Set 2 cannot derive AB → E since in set 2 (AB)+ = {A, B, C}
The two sets of functional dependencies are not the same and hence one cannot be minimal of other.
Set 1 = {AB → C, D → E, AB → E, E→ C}
Set 2 = {AB → C, D → E, E → C}
Set 2 cannot derive AB → E since in set 2 (AB)+ = {A, B, C}
The two sets of functional dependencies are not the same and hence one cannot be minimal of other.
Free Test
FREE
| Start Free Test |
Community Answer
Given the following two statements:S1: Every table with two single-val...
Explanation:
S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF
- This statement is FALSE.
- A table with two single-valued attributes may not necessarily be in 3NF or BCNF.
- For a table to be in 3NF, it should be in 1NF and 2NF first, and for a table to be in BCNF, it should be in 3NF.
- Therefore, S1 is incorrect.
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
- This statement is TRUE.
- A minimal cover for a set of functional dependencies is a set of dependencies that is both minimal and logically equivalent to the original set.
- In this case, the given set of functional dependencies AB → C, D → E, E → C can be simplified to AB → C, D → E, E → C.
- Therefore, S2 is correct.
Therefore, the correct answer is option 'A' where S1 is FALSE and S2 is TRUE.
S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF
- This statement is FALSE.
- A table with two single-valued attributes may not necessarily be in 3NF or BCNF.
- For a table to be in 3NF, it should be in 1NF and 2NF first, and for a table to be in BCNF, it should be in 3NF.
- Therefore, S1 is incorrect.
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
- This statement is TRUE.
- A minimal cover for a set of functional dependencies is a set of dependencies that is both minimal and logically equivalent to the original set.
- In this case, the given set of functional dependencies AB → C, D → E, E → C can be simplified to AB → C, D → E, E → C.
- Therefore, S2 is correct.
Therefore, the correct answer is option 'A' where S1 is FALSE and S2 is TRUE.
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
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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect answer is option 'A'. Can you explain this answer?
Question Description
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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect 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 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect 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 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect answer is option 'A'. Can you explain this answer?.
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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect 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 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect 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 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect answer is option 'A'. Can you explain this answer?.
Solutions for 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect 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 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect answer is option 'A'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of
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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect answer is option 'A'. Can you explain this answer?, a detailed solution for 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect answer is option 'A'. Can you explain this answer? has been provided alongside types of 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect answer is option 'A'. Can you explain this answer? theory, EduRev gives you an
ample number of questions to practice 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?a)S1 is TRUE and S2 is FALSEb)Both S1 and S2 are TRUE.c)S1 is FALSE and S2 is TRUEd)Both S1 and S2 are FALSECorrect 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