Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
normalization and data integrity
12
Normalization and Data Integrity
Christina Padilla
Group C
What to know first
Normalization and Data Integrity go hand and hand. Before explaining why, we need to first understand what both of these words mean.
What is it?
Normal-izaton
Normalization is defined as a process that helps simplify the database in its most optimal structure in the simplest form by organizing the attributes and relations to reduce data redundancy.
A differnent way to look at it
A Bit More
"Data normalization is generally considered the development of clean data.... Simply put, this process includes eliminating unstructured data and redundancy (duplicates) in order to ensure logical data storage."
https://www.bmc.com/blogs/data-normalization/
An Easier Way to Understand
Simpler
It helps eleminates errors and repitition by organizing the data.
It simplifies data like how you simpify a fraction so its easier to understand.
So what is Data Integrity?
Data Integraty
Data integrity can simply be defined as the accuracy of the data.
Different words
"Data integrity is a concept and process that ensures the accuracy, completeness, consistency, and validity of an organization’s data. By following the process, organizations not only ensure the integrity of the data but guarantee they have accurate and correct data in their database."
A Little Bit More
https://www.fortinet.com/resources/cyberglossary/data-integrity
With Normalization being a way to
simplify data so you can spot redundancies and inaccuracies easily, it automatically leads to data integrity. The data would be correct, accurate,
and consistent and that in itself is Data integrity.
Now We Know
All
Websites Used
https://www.educba.com/normalization-in-dbms/
https://sis.binus.ac.id/2018/01/17/drawbacks-of-normalization/#:~:text=As%20we%20all%20know%2C%20normalization,it%20achieves%20the%20optimum%20structure.
Work Cited
https://www.talend.com/resources/what-is-data-integrity/#:~:text=Data%20integrity%20is%20the%20overall%20accuracy%2C%20completeness%2C%20and,and%20standards%20implemented%20during%20the%20design%20phase%20.
https://www.fortinet.com/resources/cyberglossary/data-integrity
https://www.bmc.com/blogs/data-normalization/
***Note you'll have to copy and past to access the websites