Normalization Essay

1012 words - 5 pages

Assignment 2
Normalization

Table of Contents
1. Introduction to Normalization
2. Steps to Convert Database Table into First, Second and Third Normal Forms
3. Illustration – Reason to Convert Database Table into First, Second and Third Forms
4. Explain Situations when De-Normalization is Acceptable with an Illustration
5. Impact of Business Rules on Database Normalization and Decision to De- normalize it

1. 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 ...view middle of the document...

2.3 Conversion to Third Normal Form
To convert database to 3NF, following guidelines need to be followed –
* You need to satisfy the requirements of 2NF
* Eliminate those columns that are not reliant on the primary key
3. 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 details | Course details | Result details |
| | |
1001 Joseph 11/09/1986 | M4 basic maths 7 | 11/11/2004 89 A |
1002 Michelle 12/08/1987 | M4 basic maths 7 | 11/11/2004 78 B |
1001 Joseph 23/06/1987 | H6 4 | 11/11/2004 87 A |
1003 Amanda 16/07/1985 | C3 basic chemistry 11 | 11/11/2004 90 A |
1004 Christina 24/09/1988 | B3 8 | 11/11/2004 78 B |
1002 Michelle 23/06/1988 | P3 basic physics 13 | 11/11/2004 67 C |
1005 Joe 14/09/1987 | P3 basic physics 13 | 11/11/2004 78 B |
1003 Amanda 23/10/1987 | B4 5 | 11/11/2004 67 C |
1005 Joe 13/03/1990 | H6 4 | 11/11/2004 56 D |
1004 Christina 21/08/1987 | M4 basic maths 7 | 11/11/2004 78 B |

Though this table seems to be very well organized but looking at it carefully, you will come across various anomalies. Let now look at how converting it to 1NF, 2NF and 3NF will make it more efficiently organized.
Converting it to the first normal form, we will remove any duplicate content found in the original table and form separate column for each group like – Student’s details, Course details and Result details. Once we do this we convert it to second form for more organization.
Second normal form exists when the table is in first form and no dependency exists between key and non-key attributes. We organize the second form by creating separate groups – Student table will have three columns stating the roll number of student, their names and their date of birth. Similarly the...

Other Papers Like Normalization

Scientific Ethics Essay

4617 words - 19 pages principle of normalization, which held that people who are developmentally disabled should have their desires and choices, respected, and should be able to live as normal people do, with the same life patterns and development experiences” Nirrje and others argued that normalization was equally a applicable to people with severe disabilities as it was for people with mild impairments. Ultimately, parents organizing, expanding institutional acceptances

Competency Matrix Essay

1812 words - 8 pages to be speced No knowledge of scripting tools Batch files/shell scripts Perl/Python/Ruby/VBScript/Powershell Has written and published reusable code database Thinks that Excel is a database Knows basic database concepts, normalization, ACID, transactions and can write simple selects Able to design good and normalized database schemas keeping in mind the queries that’ll have to be run, proficient in use of views, stored

What's Feminism Got To Do With Economy? A Study Of The Practice Of Prostitution

5501 words - 23 pages commercial sex-workers, have emerged out of the confluence of these disparate political agendas. The recent crack -down on Johns and the normalization of other forms of commercial sex go hand in hand because in addition to struggles over sex and gender, both the state policing of street-level sex trade and the normalization of sex business reveal a shared set of economic and cultural interests. Both street level policing and cultural normalization

The Largest And Best Association In The Free Paper Industry

2067 words - 9 pages based on the Daubechies 4 (‘db4’) [9] and Daubechies 1 (‘db1’) [9] mother wavelets respectively. Fig 4: Segmentation of the Power Oscillation Signal using the db4 Mother Wavelet. 7. ADJUSTED HAAR WAVELET METHOD In general, the FIR scaling filter for the Haar wavelet looks like h = 0.5 [1 1] , where 0.5 is the normalization factor. As adjustment and hence improvement of the characteristics of the Haar wavelet, we propose to

Economy After Cold War

3190 words - 13 pages created near full employment. Immediate post-war policy Among the causes can be mentioned the rapid normalization of political relations between former Axis powers and the western Allies. After the war, the major powers were determined not to repeat the mistakes of the Great Depression, some of which were ascribed to post–World War I policy errors. The Marshall Planfor the rebuilding of Europe is most credited for reconciliation, though the

Use Of Library

3251 words - 14 pages generations of students without consideration of the currency of content. The acceptance and “normalization” of this style of teaching by universities results in the subliminal devaluing of the commonly accepted university culture which demands independent research, critical analysis and use of current information as part of learning (Horava, 2005). The McFarlane Report considers teaching functions as consisting of orienting, motivating

Paper

2971 words - 12 pages . 2013. Web. 15 Nov. 2013. Hassan, N. A., M. F. Salem, and M. A. E. L. Sayed. "Doping And Effects Of Anabolic Androgenic Steroids On The Heart: Histological, Ultrastructural, And Echocardiographic Assessment In Strength Athletes." Human & Experimental Toxicology 28.5 (2009): 273-283. Academic Search Complete. Web. 30 Oct. 2013. Pappa, Evdokia, and Eileen Kennedy. "‘It Was My Thought … He Made It A Reality’: Normalization And Responsibility

It Assistant

5796 words - 24 pages instance in the parent entity. Basically, the modality of a relationship indicates whether the child-entity instance is required to participate in the relationship. (Dennis, Wixom, Roth, 2009, p218) The basic steps in building an ERD are (1) identify the entities, (2) add the appropriate attributes to each entity, and (3) draw relationships among entities to show how they are associated with one another. Normalization is the process whereby

Lafarge S.A

2924 words - 12 pages NAME: IHEKANANDU KINGSLEY N. COURSE: MGMT 292 / F12 N01 TITLE: INDIVIDUAL CASE STUDY (LAFARGE S.A.) SUBMITTED: October 5, 2012 TABLE OF CONTENTS 2. INTRODUCTION 3 3. DESCRIPTION OF CASE 4 4. VALUES 4 4.1. Types of values 4 5. TEAMWORK 7 6. MOTIVATION 8 7. CREATIVITY 9 7.1. Components of creativity 9 8. CONCLUSION 12 9. BIBLIOGRAPHY 13 INTRODUCTION This report aims to provide an in-depth analysis of initiatives pursued by Lafarge as

Finance

665 words - 3 pages Financial statements are the most common tool used for making business decisions. They consist of the balance sheet, income statement and statement of cash flows. The analysis tools used affect all aspects of a company not just a few. A systematic review of the resources a company used to achieve its mission is cost control. Cash flow should be kept at necessary levels for operations is one of the major benefits of cost control. It is a very

Analysis Of Operation Blue Star And Its Effects On The Gandhi Dynasty

934 words - 4 pages The period of time including and following Operation Blue star is considered a dark time in India and black spot in Indian history. It is a time Indian would rather forget, yet still to this day debate about. Was Indihar Gandhi correct in instating operation Blue Star, inflicting damage to the Golden temple, and being responsible for the killing of anywhere from 492 (official reports) to 1500 (estimates run as high as) civilians, which lead to an

Related Essays

Pt2520 Unit 5 Assignment 1,Unit 5 Research Paper 1 And Quiz 4

1792 words - 8 pages following is true of documenting normalization? A) Only the normalized design needs to be documented even if some denormalization was done B) Only the denormalized design needs to be documented C) All changes in normalized and denormalized design should be documented D) None of the above 10) ____Which of the following is the normal form that removes all transient dependencies? A) Second Normal Form B) Boyce Codd Normal Form C) Third Normal

Sex Paper

663 words - 3 pages intertwined the plots motion pictures. Pretty Baby, and Blame it on Rio are two examples given to express the normalization of nudity in front of the camera (Sarracino 147). These were important films because it took porn completely away from the shadows and set it firmly in our living rooms. Despite the authors detail we are giving very little emotion and the article only seems to be focused on one point of view. This is especially apparent in

Mis 535 Week 3 Quiz Essay

893 words - 4 pages Explanation: | p. 221 | | |   | Points Received: | 1 of 1 |   | Comments: | | | |  14. | Question : | What is the process of streamlining data to minimize redundancy and awkward many-to-many relationships? | |   | Student Answer: | |  Normalization |   | | |  Data scrubbing |   | | |  Data cleansing |   | | |  Data defining |   | Instructor Explanation: | p. 219 | | |   | Points Received: | 1 of 1

Hrm In Service Sector Essay

2303 words - 10 pages , therefore, it was decided that a normalization committee would look at the marks in the head office. From 2008 onwards, normalization committees at head office would normalize the marks for employees holding comparable positions across all stores so that the following distribution was enforced for each level of employees. Table C links the rewards in terms of pay hike with the grades awarded. Table C: Salary hike in terms of awarded grade