Essay About Database Table And 1Nf

Normalization
Assignment 2NormalizationTable of Contents1. Introduction to Normalization2. Steps to Convert Database Table into First, Second and Third Normal Forms3. Illustration – Reason to Convert Database Table into First, Second and Third Forms4. Explain Situations when De-Normalization is Acceptable with an Illustration5. Impact of Business Rules on Database Normalization and Decision to De- normalize it1. Normalization The process to organize a data in a database efficiently is termed as Normalization. With an aim to eliminate redundant data and ensuring the logic of data dependency, normalization is a process used by various businesses and colleges for efficient data recording. It helps in storing the data logically and reduces the space taken by it. To normalize a database, one uses a prescribed set of series which are termed as normal forms. There are typically three normal forms – first or 1NF, second or 2NF, third or 3NF. Practically only these three forms are applied, however sometimes 4NF and 5NF can be used. 2. Steps to Convert Database Table into First, Second and Third Normal FormsTo convert an unorganized database table into first, second and third normal forms; following steps shall be applied:2.1 Conversion to First Normal FormWhile converting the database table to 1NF, you should follow these guidelines – Remove duplicity by eliminating those columns from the database table that appear more than once.Related data should be organized in separate tables and classify the primary key i.e. recognise each row with a distinct column or set of columns. 2.2 Conversion to Second Normal Form To convert to 2NF, follow these guidelines – You should meet the guidelines of 1NFEliminate the subsets of data given in multiple rows and group them in separate tablesUsing foreign keys for creating association between the new table and its predecessors.2.3 Conversion to Third Normal FormTo convert database to 3NF, following guidelines need to be followed – You need to satisfy the requirements of 2NFEliminate those columns that are not reliant on the primary key3.  Illustration – Reasons for Conversion of Database to 1NF, 2NF and 3NF.Let’s illustrate an example that shows the reason to convert the database table to 1NF, 2 NF and 3NF.Student detailsCourse detailsResult details [pic 1][pic 2][pic 3][pic 4][pic 5][pic 6]1001     Joseph       11/09/1986M4        basic maths        711/11/2004       89     A1002   Michelle      12/08/1987M4        basic maths        711/11/2004       78      B1001    Joseph         23/06/1987H6                                    411/11/2004      87        A1003    Amanda     16/07/1985C3      basic chemistry      1111/11/2004     90        A1004   Christina      24/09/1988B3                                      811/11/2004      78      B1002    Michelle      23/06/1988P3       basic physics         1311/11/2004     67       C1005    Joe                14/09/1987P3      basic physics          1311/11/2004     78        B1003   Amanda         23/10/1987B4                                     511/11/2004      67       C1005    Joe              13/03/1990H6                                     411/11/2004      56       D1004   Christina     21/08/1987M4      basic maths            711/11/2004       78      B