Define 3nf normal form, Database Management System

3NF Normal Form

A relation schema R is in 3NF if it is in 2NF and for each FD X A either of the following is true

  • X is a Super-key of R.
  • A is a prime attribute of R.

In other words, if every non prime attribute is non-transitively related on primary key.

 

 

698_3 NF Normal Form.png

Posted Date: 7/30/2012 2:23:33 AM | Location : United States







Related Discussions:- Define 3nf normal form, Assignment Help, Ask Question on Define 3nf normal form, Get Answer, Expert's Help, Define 3nf normal form Discussions

Write discussion on Define 3nf normal form
Your posts are moderated
Related Questions
What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

Project Description: The work is about founding the best skilled person for the job. I will give you the job description. Skills required are Data Entry, Database Administrat

Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter

1. Determine the set of minimal functional dependencies for the following data. The local bakery, Happy Cakes, needs your help designing a database that will support a kiosk in

The data of a view is not physically stored, but derived from one or more tables. True the data of a view is not physically stored

Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T

Relational Model: The relational model uses a collection of tables to represent both data and the relationships among those data. Each table has multiple columns and each column h