Database Normalization: A Review

Authors

  • Vinita Panwar Assistant Professor, RD engineering college, duhai, Ghaziabad

Keywords:

normalized, combinatorial, dependencies, Database Normalization, Formalized Guidelines, Modular System

Abstract

Database normalization theory offers formalized guidelines how to reduce data redundancy and thus problems that it causes in databases. More lately, researchers have started to formalize ideas that the problems caused by unwanted dependencies and redundancy can be observed in case of any modular system like software, hardware, or organization. To tackle these problems, they have proposed the theory of normalized systems that complete application frees systems of combinatorial effects and thus the impact of a change in a system does not depend on the system size. The theory of normalized systems do not say much about database normalization, the theories are deeply related. The Common ground of the database normalization theory and the theory of normalized systems.

References

Ernst, N.A. 2012. On the role of requirements in understanding and managing technical debt. Proceedings of the Third International Workshop on Managing Technical Debt (2012), 61–64.

Albarak, M., & Bahsoon, R. (2018). Prioritizing technical debt in database normalization using portfolio theory and data quality metrics. Proceedings - International Conference on Software Engineering, 31–40. https://doi.org/10.1145/3194164.3194170

Bahmani, A. H., Naghibzadeh, M., & Bahmani, B. (2008). Automatic database normalization and primary key generation. Canadian Conference on Electrical and Computer Engineering, (June 2008), 11–16. https://doi.org/10.1109/CCECE.2008.4564486

Ebrahim, M. E. A. (n.d.). Project-DatabaseNormalization. Retrieved from https://www.researchgate.net/publication/333972824_Project-Database_Normalization

Eessaar, E. (2016). The Database Normalization Theory and the Theory of Normalized Systems: Finding a Common Ground. Baltic J. Modern Computing, 4(1), 5–33. Retrieved from https://www.researchgate.net/publication/297731569_The_Database_Normalization_Theory_and_the_Theory_of_Normalized_Systems_Finding_a_Common_Ground/link/56e18d9508ae40dc0abf50a1/download

Jmeter. (n.d.). What is Normalization. Retrieved from https://www.guru99.com/database-normalization.html

Pratiyushsah. (2020). Normal Forms in DBMS. Retrieved from https://www.geeksforgeeks.org/normal-forms-in-dbms/

SINGH, C. (n.d.). Normalization in DBMS: 1NF, 2NF, 3NF and BCNF in Database. Retrieved from https://beginnersbook.com/2015/05/normalization-in-dbms/

Wang, T. J. (T. J. ., Du, H., & Lehmann, C. M. (2010). Accounting For The Benefits Of Database Normalization. American Journal of Business Education (AJBE), 3(1), 41–52. https://doi.org/10.19030/ajbe.v3i1.371

Downloads

Published

30-06-2020

How to Cite

Vinita Panwar. (2020). Database Normalization: A Review. International Journal for Research Publication and Seminar, 11(2), 4–16. Retrieved from https://jrps.shodhsagar.com/index.php/j/article/view/1104

Issue

Section

Original Research Article