Boyce-Codd Normal Form - Database Design - Lecture Slides, Slides for DBMS (Database Management Systems). English and Foreign Languages University

DBMS (Database Management Systems)

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
Showing pages  1  -  4  of  14
Boyce-Codd Normal Form
1NF, 2NF, and 3NF
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
First Normal Form
Eliminate Repeating Groups
Require uniquely identified rows
The preview of this document ends here! Please or to read the full document or to download it.
Document information
Embed this document:
Docsity is not optimized for the browser you're using. In order to have a better experience please switch to Google Chrome, Firefox, Internet Explorer 9+ or Safari! Download Google Chrome