Assignment 5: Logical Design, Part II



Assignment 5: Logical Design, Part II

Letter

Dear Executive,

Database normalization is in favor of the efficient system as it removes the redundant data from the tables. It ensures the storage efficiency, scalability, and data integrity. With the process of normalization, data dependencies are justified, and the space consumption id reduced. It proceeds in the relational model of quantifying the entire database into different normal forms (NF). These conversions are followed by the use of algorithms among them. On the contrary, normalization splits the existing tables of data into multiple tables that make the system complicated as these tables are required to be rejoined repeatedly at the time of any query (Coronel & Morris, 2012).

There are many advantages to normalizing databases. The first being the ability to minimize the modification abnormality by reducing data redundancy, sustain data stability and protect data uprightness. Modification abnormality arises when data is inputted, updated, or deleted, or it has been misplaced by some other reason. Normalization can also be used to enforce referential integrity constraints which can lead to the inability to extract important data or relate information from one table with data in another table because there is nothing on which to join the two tables (Databasedev, 2013).

Another advantage is space related. By removing duplicate data, designers can conserve disk space and increase the amount of row space available for other fields. Primary and foreign keys also lead to the creation of indexes in some databases which in turn speed up query performance.

Problems Associated with Data Redundancy

The three most significant problems associated with the data redundancy which are wasted storage space, more difficult database updates and a possibility if inconsistent data. Data redundancy is a significant issue in the database as it allows the duplication of data that consume enough space ...