Civil Engineering (CE) Exam  >  Civil Engineering (CE) Questions  >  Consider a relation R (A, B, C, D, E, F, G, H... Start Learning for Free
Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.
CH → G
A → BC
B → CFH
E → A
F → EG
The relation R is ______.
  • a)
    in 1NF but not in 2NF
  • b)
    in 2NF but not in 3NF
  • c)
    in 3NF but not in BCNF
  • d)
    in BCNF
Correct answer is option 'A'. Can you explain this answer?
Most Upvoted Answer
Consider a relation R (A, B, C, D, E, F, G, H), where each attribute i...
Explanation:

1NF:
- A relation is in 1NF if all attributes are atomic, which is the case in the given relation R (A, B, C, D, E, F, G, H).

2NF:
- A relation is in 2NF if it is in 1NF and all non-prime attributes are fully functionally dependent on the primary key.
- In the given relation, the functional dependency CH -> G violates the 2NF as G is not fully dependent on the primary key.
Therefore, the relation R is in 1NF but not in 2NF.
Free Test
Community Answer
Consider a relation R (A, B, C, D, E, F, G, H), where each attribute i...
Since attribute D is not a part of any FD, it must be a part of the candidate key.
AD+ = {ABCDEFGH}
BD+ = {ABCDEFGH}
ED+ = {ABCDEFGH}
FD+ = {ABCDEFGH}
CD+, GD+, and HD+ do not all the attributes. So, they can not be candidate keys.
Candidate keys are AD, BD, ED, and FD.
A → BC, B → CFH, and F → EG are partial dependencies. So, the relation is not in 2NF.
Hence the relation is in 1NF but not in 2NF.
Explore Courses for Civil Engineering (CE) exam

Top Courses for Civil Engineering (CE)

Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect answer is option 'A'. Can you explain this answer?
Question Description
Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect 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 relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect 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 relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect answer is option 'A'. Can you explain this answer?.
Solutions for Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect 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 relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect answer is option 'A'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect answer is option 'A'. Can you explain this answer?, a detailed solution for Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect answer is option 'A'. Can you explain this answer? has been provided alongside types of Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect answer is option 'A'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.CH → GA → BCB → CFHE → AF → EGThe relation R is ______.a)in 1NF but not in 2NFb)in 2NF but not in 3NFc)in 3NF but not in BCNFd)in BCNFCorrect 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

Top Courses for Civil Engineering (CE)

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev