Access over 20 million homework & study documents

Database Normalization Presentation

Content type
User Generated
Showing Page:

Sign up to view the full document!

lock_open Sign Up
Showing Page:

Sign up to view the full document!

lock_open Sign Up
Showing Page:

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 68 pages?
Access Now
Unformatted Attachment Preview
Normalization Database Normalization 1 Database Normalization ⚫ Database normalization is the process of removing redundant data from your tables to improve storage efficiency, data integrity, and scalability. ⚫ In the relational model, methods exist for quantifying how efficient a database is. These classifications are called normal forms (or NF), and there are algorithms for converting a given database between them. ⚫ Normalization generally involves splitting existing tables into multiple ones, which must be re-joined or linked each time a query is issued. 2 History ⚫ Edgar F. Codd first proposed the process of normalization and what came to be known as the 1st normal form in his paper A Relational Model of Data for Large Shared Data Banks Codd stated: “There is, in fact, a very simple elimination procedure which we shall call normalization. Through decomposition non-simple domains are replaced by ‘domains whose elements are atomic (non-decomposable) values.’” 3 Normal Form ⚫ Edgar F. Codd originally established three normal forms: 1NF, 2NF and 3NF. There are now others that are generally accepted, but 3NF is widely considered to be sufficient for most applications. Most tables when reaching 3NF are also in BCNF (Boyce-Codd Normal Form). 4 Why Normalize? ⚫ Flexibility ⚫ ⚫ Structure supports many ways to look at the data Data Integrity ⚫ “Modification Anomalies” Deletion ⚫ Insertion ⚫ Update ⚫ ⚫ Efficiency ⚫ El ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Great content here. Definitely a returning customer.


Similar Documents