All Courses
Explore Courses UPSC Exam UPSC Test Series Free Notes EduRev Infinity Get the App Login Join for Free
Sign in Open App
Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  A relation in which every non-key attribute i... Start Learning for Free
SaveJoin the Discussion on the App
A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -
  • a)
    3NF
  • b)
    BCNF
  • c)
    5NF
  • d)
    4NF
Correct answer is option 'A'. Can you explain this answer?
FREE This question is part of
Download PDF Attempt Test
Download PDF Attempt this Test
Most Upvoted Answer
A relation in which every non-key attribute is fully functionally depe...
1NF:
  • There are only Single Valued Attributes.
  • There is a unique name for every Attribute/Column.
2NF:
  • A relation that is in First Normal Form 
  • Every non-primary-key attribute is fully functionally dependent on the primary key 
3NF
  • The third normal form is based on the concept of transitive dependency. A functional dependency X->Y in a relation schema R is a transitive dependency if there exists a set of attributed Z in R that is neither a candidate key nor a subset of any key of R.
  • A relation is in 3NF if it satisfies 2NF and no prime attribute of R is transitively dependent on the primary key.
  • If X - > A is a functional dependency, then A should be a prime attribute or X should be a candidate key.
  • Lossless join and dependency preservation is always possible in 3NF. 3NF decomposition is always lossless join and dependency preserving.
BCNF:
  • It stands for Boyce Codd normal form.
  • A relation R is in BCNF if whenever a non-trivial functional dependency X -> A holds in R, then X is a superkey of R. Any relation with two attributes is always in BCNF. Because when a relation contains only two attributes then one attribute determines another and the left side of the functional dependency will always be a candidate key in that case.
  • BCNF is not always dependency preserving.
Therefore the answer is Option 1.
< Previous Question Next Question >
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)View all

Top Courses for Computer Science Engineering (CSE)

A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect answer is option 'A'. Can you explain this answer?
Question Description
A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect 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 A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect 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 A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect answer is option 'A'. Can you explain this answer?.
Solutions for A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect 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 A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect answer is option 'A'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect answer is option 'A'. Can you explain this answer?, a detailed solution for A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect answer is option 'A'. Can you explain this answer? has been provided alongside types of A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect answer is option 'A'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in -a)3NFb)BCNFc)5NFd)4NFCorrect 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

Suggested Free Tests

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
Get App
© EduRev
Education Revolution
Follow Us
Signup to see your scores go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup