Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) 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?
Verified Answer
Consider a relation R (A, B, C, D, E, F, G, H), where each attribute i...
If we find closure of A: A+ → All attribute except D. Similarly for other keys we can find closure, but D can't be derived from any key and it must be added to all keys to be derived from. That's why this relation is in 1NF, since there is partial dependency so, this relation is not in 2NF. So, option (A) is correct.
View all questions of this test
Most Upvoted Answer
Consider a relation R (A, B, C, D, E, F, G, H), where each attribute i...
Explanation:

1NF:
- The relation R is in 1NF because all attributes are atomic, meaning they cannot be further divided.
- Each attribute contains single values without any repeating groups.

2NF:
- A relation is in 2NF if it is in 1NF and every non-prime attribute is fully functionally dependent on the primary key.
- In this case, the functional dependency A → EG violates 2NF as A is not a part of the candidate key.
Therefore, the relation R is in 1NF but not in 2NF.
Explore Courses for Computer Science Engineering (CSE) exam

Similar Computer Science Engineering (CSE) Doubts

Top Courses for Computer Science Engineering (CSE)

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 Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) 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 Computer Science Engineering (CSE) 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 Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) 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 Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

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