Third Normal form (3NF) :A table design is said to be in 3NF if both the following conditions hold:Table must be in 2NFTransitive functional dependency of non-prime attribute on any super key should be removed.An attribute that is not part of any candidate key is known as non-prime attribute.In other words 3NF can be explained like this: A table is in 3NF if it is in 2NF and for each functional dependency X- Y at least one of the following conditions hold:X is a super key of tableY is a prime attribute of attribute that is a part of one of the candidate keys is known as prime attribute.

Question

Third Normal form (3NF) :A table design is said to be in 3NF if both the following conditions hold:Table must be in 2NFTransitive functional dependency of non-prime attribute on any super key should be removed.An attribute that is not part of any candidate key is known as non-prime attribute.In other words 3NF can be explained like this: A table is in 3NF if it is in 2NF and for each functional dependency X-> Y at least one of the following conditions hold:X is a super key of tableY is a prime attribute of attribute that is a part of one of the candidate keys is known as prime attribute.

Lalitesh sharma · Accepted Answer

Third Normal form (3NF) :A table design is said to be in 3NF if both the following conditions hold:Table must be in 2NFTransitive functional dependency of non-prime attribute on any super key should be removed.An attribute that is not part of any candidate key is known as non-prime attribute.In other words 3NF can be explained like this: A table is in 3NF if it is in 2NF and for each functional dependency X-> Y at least one of the following conditions hold:X is a super key of tableY is a prime attribute of attribute that is a part of one of the candidate keys is known as prime attribute.

What is the third part if we divide 3300 into three parts in such that one third of the first part, half of the second part a...

Three labourers worked together for 30 days, in the course of work, all of them remained absent for few days. One of them was...

If a magnet has a third pole, then the third pole is called

Out of three numbers, the first is twice the second and is half of the third. If the average of the three numbers is 56, then...

Out of three numbers, the first is twice the second and is half of the third. If the average of the three numbers is 56, then...

Q. Out of three numbers, the first is twice the second and is half of the third. If the average of the three numbers is 56, t...

Of the three numbers, the second is twice the first and it is also thrice the third. If the average of three numbers is 44, t...

Of the three numbers, the second is twice the first and it is also thrice the third. If the average of three numbers is 44, t...

Q. Of the three numbers, the second is twice the first and it is also thrice the third. If the average of three numbers is 44...

The average of three numbers is 58. First number is 3/4 of the third number. If the third number is 24 more than second numbe...

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

Study24x7

Henry Harvin

CBSE Study Materials

Digital Marketing - Learn SEO, PPC, SMO,...

Defence

UPSC & State PSC

SSC Preparation Strategies & Study Mater...

Banking/IRDA

DEFENCE EXAM PREPARATION

Get the App

UGC NET Exam Analysis & topper tips

D Block Elements On The Periodic Table | Introduction

Database Management System (DBMS)

MongoDB

LoadRunner to JMeter which one should prefer as a Performanc...

Youtube Marketing

Benefits of Learning DATABASE MANAGEMENT

Types of Database and its Uses

RELATIONAL DATABASE MANAGEMENT SYSTEM

OBJECT ORIENTED DATABASE