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
can you resolve this for me please? Database Management Systems Homework 1 The following relations are given (primary keys are underlined): PLAY-ACTOR(AId, Name, Nationality, Birt

System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

Create an index for the table Client, field CLIENT_NO of Q ? Command:   CREATE INDEX client_client_no ON client(client_no);

What is an Index? An index is a small table having only two columns. The first column has a copy of the primary or candidate key of a table and the second column having a set o

What is completeness constraint on generalization? Define the variation between total and partial design constraint. Give an example each.       Ans: Completeness Constraints

How is the database organised in Oracle? Database organized within Oracle in terms of table and table holds attributes and values. A database consists of one or more logical

What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have

Describe the types of attributes? Types of attributes: An attribute's category determines the type of values that are permitted in the attribute. For instance, the value vers