COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The database occupies less memory and is faster to search
|
|
|
There is no possibility of duplicated data anywhere in the database
|
|
|
The data is safe from hacking and illegal access
|
|
|
It is easier to edit databases tables and data
|
Detailed explanation-1: -Introduction: In this article, you will learn, what Data Integrity is and Database Normalization. Data integrity refers to the global validity and certainty of data. It is an analytical condition to the design, performance, and usage of all system which stores, processes or recover data.
Detailed explanation-2: -Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
Detailed explanation-3: -Normalization organizes attributes and relations of a database to ensure that database integrity constraints properly enforce their dependencies. It is accomplished by applying some formal rules either by the process of synthesis (creating a new database design) or decomposition (improving an existing database design).
Detailed explanation-4: -Normalization is a technique for organizing data in a database. It is important that a database is normalized to minimize redundancy (duplicate data) and to ensure only related data is stored in each table. It also prevents any issues stemming from database modifications such as insertions, deletions, and updates.