If every non-key attribute is functionally dependent on the primary key, then the relation will be in

- a)First normal form
- b)Third normal form
- c)Second normal form
- d)Fourth normal form

Correct answer is option 'C'. Can you explain this answer?

By
Anil Kumar
·
Oct 20, 2020 ·Computer Science Engineering (CSE)

DHIRENDRA GUPTA
answered
Oct 20, 2020

Conditions for various normal forms:

**1 NF –**A relation R is in first normal form (1NF) if and only if all underlying domains contain atomic values only.**2 NF –**A relation R is in second normal form (2NF) if and only if it is in 1NF and every non-key attribute is fully dependent on the primary key.**3 NF –**A relation R is in third normal form (3NF) if and only if it is in 2NF and every non-key attribute is**non-transitively**dependent on the primary key.**BCNF –**A relation R is in Boyce-Codd normal form (BCNF) if and only if every determinant is a candidate key.

Relation R(XYZ) with functional dependencies {X -> Y, Y -> Z, X -> Z}.

Notice here Y -> Z, in question it is not mention that non prime attribute is

This relation is in 2NF but not in 3NF because of every non-key attribute is

This discussion on If every non-key attribute is functionally dependent on the primary key, then the relation will be ina)First normal formb)Third normal formc)Second normal formd)Fourth normal formCorrect answer is option 'C'. Can you explain this answer? is done on EduRev Study Group by Computer Science Engineering (CSE) Students. The Questions and
Answers of If every non-key attribute is functionally dependent on the primary key, then the relation will be ina)First normal formb)Third normal formc)Second normal formd)Fourth normal formCorrect answer is option 'C'. Can you explain this answer? are solved by group of students and teacher of Computer Science Engineering (CSE), which is also the largest student
community of Computer Science Engineering (CSE). If the answer is not available please wait for a while and a community member will probably answer this
soon. You can study other questions, MCQs, videos and tests for Computer Science Engineering (CSE) on EduRev and even discuss your questions like
If every non-key attribute is functionally dependent on the primary key, then the relation will be ina)First normal formb)Third normal formc)Second normal formd)Fourth normal formCorrect answer is option 'C'. Can you explain this answer? over here on EduRev! Apart from being the largest Computer Science Engineering (CSE) community, EduRev has the largest solved
Question bank for Computer Science Engineering (CSE).

Ask a question

- jQuery Tutorial - 22 - Attribute selectors
Video | 06:17 min

- Magento 2 Tutorial #9 Magento Attribute Sets
Video | 05:20 min

- HTML The class Attribute
Doc | 1 Page

- HTML The class Attribute
Doc | 1 Page

- Angular attribute binding
Video | 06:18 min

Upgrade to Infinity