Database Normalization: A Review
Keywords:
normalized, combinatorial, dependencies, Database Normalization, Formalized Guidelines, Modular SystemAbstract
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
How to Cite
Issue
Section
License
Copyright (c) 2020 International Journal for Research Publication and Seminar
This work is licensed under a Creative Commons Attribution 4.0 International License.
Re-users must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use. This license allows for redistribution, commercial and non-commercial, as long as the original work is properly credited.