Assignment 5: Logical Design Part II

Assignment 5: Logical Design Part II

Introduce the concept of normalization in a letter to the executive and explain the pros and cons.
The main purpose of normalization is to reduce data redundancy and avoid inconsistent data. The benefits on normalizing a database would be to prevent the appearance of modification anomalies in the data. The anomalies can lead to the loss of needed data. Normalization would help with organizing your data to prevent redundancy. It would also establish and maintain the integrity of your data tables as well as eliminating inconsistent data dependencies. Each table should describe only one type of entity.
Normalization leads to separation of unrelated entities into separate entities: The pros for normalization: The fully normalized expression of a data model is very close to the most compact possible representation of data in terms of bytes per unit of information, which would help with performance A well-normalized database is faster to write and to access for the same reason which would also be a plus for performance. Normalization would cause relational inconsistencies which would mean no redundancy.
The cons for normalization: Normalization requires skill to provide functional views and access methods that are comprehensible and streamlined for consumer
Data redundancy leads to data anomalies and corruption and generally should be avoided by design. Normalization would prevent redundancy and make the best possible usage of storage. By following the principles of normalization you can achieve a design that is highly flexible allowing the model to be extended when needed to account for new attributes, entity sets, and relationships. With normalization we can reduce redundancy, both to save space and to avoid inconsistencies in data which could affect information for reporting and