Find users

Boyce-Codd Normal Form - Database Design - Lecture Slides

Slides, DBMS (Database Management Systems)

Post: April 27th, 2013
Description
These lecture slide are very easy to understand and very helpful to built a concept about the foundation of computers and Database Design.The key points in these slide are:Boyce-Codd Normal Form, Database Normalization, Normal Forms, Deletion Anomalies, First Normal Form, Eliminate Repeating Groups, Eliminate Redundant Data, Non-Key Columns, Non-Key Attributes, Third Normal Form
These lecture slide are very easy to understand and very helpful to built a concept about the foundation of computers and Database Design.The key points in these slide are:Boyce-Codd Normal Form, Database Normalization, Normal Forms, Deletion Anomalies, First Normal Form, Eliminate Repeating Groups, Eliminate Redundant Data, Non-Key Columns, Non-Key Attributes, Third Normal Form
-
Embed this document

Report Report

Reason:

Send Message

Login or register to download this document!

If you are already registered, login otherwise Register , it just takes 1 minute!

Uploaded by:

arunima

arunima
Universityuni_20documents_40doc_answ
Embed this document
Get the App
Contents
Boyce-Codd Normal Form Docsity.com Overview • 1NF, 2NF, and 3NF • BCNF • Conclusion Docsity.com Database Normalization • Each datum in the database should represented once. • Purpose is to eliminate update, insert, and deletion anomalies. • Normal Forms are increasingly strict subset of 1NF. Docsity.com First Normal Form • Eliminate Repeating Groups • Require uniquely identified rows Docsity.com First Normal form • 1 girl per row • 2 Pamelas are uniquely identifiable. Docsity.com Second Normal Form • Eliminate Redundant Data Docsity.com Second Normal Form • Non-key columns are dependent on all columns of the primary key. Docsity.com 2NF/3NF • A Relation without non-key attributes is 2NF and 3NF. Docsity.com Third Normal Form • Eliminate Columns Not Dependent On Key • i.e. if a column is in a relation, then it must be dependent on the key. Docsity.com Third Normal Form • Move non-key-dependent attributes to a new table. Docs..

Docsity.com

Learning becomes social!

Authentication required

This feature is reserved for registered user

Register Login

Docsity.com

Learning becomes social!

Authentication required

Hi!
In order to freely download all the documents on Docsity, please register or login:

Register Login