How database normalization and schema versioning improve system efficiency, data integrity, and flexibility in changing business settings

Abstract

With an emphasis on major corporations like Nokia, this thesis investigates the effects of database normalization and schema versioning on system effective-ness, data integrity, and flexibility inside database management systems. The study investigates the implementation issues and successful techniques of these technologies through semi-structured interviews with database administration specialists.

The results show that sophisticated schema versioning and normalization great-ly improve data management by enabling systems to adjust flexibly to new re-quirements without sacrificing efficiency. The study highlights several significant obstacles, including the difficulty in implementing schema modifications and the limitations imposed by company regulations. One of the highlighted effective solutions is the combination of schema management tools and version control systems to enhance traceability and rollback capabilities.