Database

Tuesday, 21 August 2012

3rd Normal Form(3NF)

A table in 3rd normal form if
  • It is in 2NF
  • It contains no transitive dependencies
If a transitive dependency exists it is removed by placnig the appropriate attribute in a new relation along with their determinant.
Posted by Unknown at 17:37
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2012 (44)
    • ►  October (4)
    • ►  September (1)
    • ▼  August (39)
      • Other SELECT commands
      • SELECT with conditions
      • SELECT statement
      • Writing SQL Commands
      • Data Manipulation
      • Structured Query Language
      • Boyce-Codd Normal Form
      • Key Types
      • Improving the Design
      • 2NF to 3NF
      • 3rd Normal Form(3NF)
      • 1NF to 2NF
      • 2nd Normal Form(2NF)
      • UNF to 1NF
      • 1st Normal Form(1NF)
      • UN-Normalized Form(UNF)
      • Data Redundancy
      • Functional dependency
      • Normalization
      • Data Dictinary
      • Integrity Rules
      • Foreign Key
      • Converting From ERD
      • Converting from ERD
      • Relational Model
      • ERD making tips
      • Composite Entities
      • Super and Sub Type
      • Composite Keys
      • Primary Keys
      • Entity
      • Entity Relationship Diagram(ERD)
      • Basic Modeling Concepts
      • The Database Model
      • Database Design
      • Database Systems Environment
      • DBMS Functions
      • Types of Database
      • Introducing the Database
Picture Window theme. Theme images by ULTRA_GENERIC. Powered by Blogger.