Database Management System - Database Normalization.pptx

Lesson for Database

1. DATABASE NORMALIZATION Prepared by: Joshua F. Madera, LPT, MIT

2. Review of the previous Lesson Traditional DB VS Relational DB

3. Preliminary Activity

4. Guide Questions 1. How do you find the activity? 2. How did you arrange the blocks or what factors did you considered in arranging/organizing the blocks? 3. Why it is important to arrange and organize database? 4. What are the possible problems that you may encounter if a database has redundancies and anomalies ?

5. Normalization Normalization is the process of organizing data in a database. It includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.

6. Types of Normal Form 1. First Normal Form (1NF): Eliminate duplicate columns from the same table and create separate tables for related data.

7. Types of Normal Form 2. Second Normal Form (2NF): Ensure that all non-key attributes are fully functional dependent on the primary key.

8. Types of Normal Form 3. Third Normal Form (3NF): Ensure that all attributes are not only fully functional dependent on the primary key but also are non-transitive. 4. Boyce- Codd Normal Form (BCNF): Handle certain types of anomalies that 3NF does not cover.

9. Reference https:// learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description .