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
Define Query Processing Query processing is the process of selecting the best plan or strategy to be employed in responding to a database request. The plan is then executed to

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass

Consider the relation PERSON. If you want to display details of persons having age less than or equal to 30 than the select operation will be used as follows: σ AGE The resu

4. Describe three ways to handle missing field values

I have 10+ yrs exp in oracle Sql ,Pl/SQl,Forms ,Reports. I am expert in assignements & Online tutoring so i want to join you. Please guide me. Thanks Brajesh Shukla +91 9899641535

#floating point representation is used to store

Example: RELATIONAL SCHEMA for PERSON: PERSON (PERSON_ID: integer, NAME: string, AGE: integer, ADDRESS: String) RELATION INSTANCE In this instance, m = 3 and n = 4

(A) For the relation; CarSales (RegNo, BuyerName, Address, SalesPerson, Make, Model, Commission) The following functional dependences hold, RegNo _ID à Make, Model Reg

A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

Determine Which is not a consequence of concurrent operations? Ans: Update anomaly.