Differences

This shows you the differences between two versions of the page.

--- databases:normalization [2022/12/22 15:33] – created dimitrij
+++ databases:normalization [2022/12/22 16:22] (current) – [Normal Forms] dimitrij
@@ Line 22: / Line 22: @@
 ===== Normal Forms =====
-The normalization follows this steps which build up on each other and make up rules, which help to design a more robust database.
+The normalization follows this steps which build up on each other and make up rules, which help to design a more robust database. The normal forms define what condition needs to be satisfied to complete the normalication for thsi step.
-    First Normal Form (1NF)
+==== First Normal Form (1NF) ====
-    Define 1NF and explain its main characteristics
+To satisfy First normal form, each column of a table must have a single value. Columns which contain sets of values or nested records are not allowed.
-    Discuss the benefits of 1NF, such as reducing data redundancy and improving data integrity
-    Provide examples of how to apply 1NF to a database
-    Second Normal Form (2NF)
+=== Benefits ===
-    Define 2NF and explain its main characteristics
+This may introduce redundancy at first, but because the fields are now in there smallest form, they can be defined as a primitiv data type and make the data more consistent
-    Discuss the benefits of 2NF, such as further reducing data redundancy and improving data integrity
-    Provide examples of how to apply 2NF to a database
-    Third Normal Form (3NF)
+==== Second Normal Form (2NF) ====
-    Define 3NF and explain its main characteristics
+If a table has a single column primary key, it automatically satisfies 2NF, but if a table has a multi-column or composite key then it may not satisfy 2NF. The second Part of the rule is obsolete, when every non primary key attribute is dependent on all parts of the composit primary key.
-    Discuss the benefits of 3NF, such as further reducing data redundancy and improving data integrity
-    Provide examples of how to apply 3NF to a database
-    Fourth Normal Form (4NF) and beyond
+=== Benefits ===
-    Introduce higher levels of normalization, such as 4NF and 5NF
+This forces the databases designer to extract data which does not belong to every part of the composit key and makes the database more consistent.
-    Discuss the benefits of higher levels of normalization and when they may be necessary
-    Provide examples of how to apply higher levels of normalization to a database
-    Conclusion
+==== Third Normal Form (3NF)====
-    Summarize the importance of normalization in database design
+The database is in the 3 normal form, when there are no transitive dependencies in the table (i.e., no non-key field depends on another non-key field).
-    Emphasize the benefits of normalization in terms of data efficiency and integrity
-    Encourage the audience to consider the principles of normalization when designing their own databases.
+==== Fourth Normal Form (4NF) and beyond ====
+Introduce higher levels of normalization, such as 4NF and 5NF. Discuss the benefits of higher levels of normalization and when they may be necessary. Provide examples of how to apply higher levels of normalization to a database
+==== Conclusion ====
+Summarize the importance of normalization in database design. Emphasize the benefits of normalization in terms of data efficiency and integrity. Encourage the audience to consider the principles of normalization when designing their own databases.