- Tags:
- Show more
- Pages:
- 3
- Words:
- 825
Normalization Student’s Name Institutional Affiliation Assignment2: Normalization Abstract Normalization is a term that is used in reference to databases and is used to refer to the process by which data in databases is organized in such a way that data redundancy is eliminated or greatly reduced. The process of normalization also ensures that data integrity in databases is improved. The process of normalization can be a basic one or it can take complex forms. In this regard, normalization can take several forms; First Normal Form, Second Normal Form, The third Normal Form and BCNF (Boyce and Codd Normal Form). While the First Normal form (usually abbreviated as 1NF) is the most basic with only two dimensions, rows and columns, the BCNF form is the most complex and handles anomalies that cannot be handled in the third normal form. Data normalization ensures that retrieval of data is easy and, therefore, when querying databases, precision of the data retrieved can be guaranteed (Aleyksandr, 2012). This paper will discuss normalization, look at its practical applications as well as how normalization affects organizations in the real world. Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form. First normal form: involves having a table whose attribute doesn’t contain multiple values. For instance, take the table below; Student Name Registration Number Address John L3457 1234-456 Tom L5674 4566-987 7685-123 Dan L6795 4789-064 Fig1: a tabled example not satisfying 1NF. From the table above, it is that the address attribute holds multiple values for Tom. To
Leave feedback