 |
|
#1
01-18-2012, 05:41 PM
|
||||
|
||||
CS403 Gdb Solution fall 2011
“Normalization Process removes the anomalies from the data but ultimately it affects the Query Performance of DML operations:” why..? Justify the statement.
|
|
#2
01-19-2012, 05:43 PM
|
||||
|
||||
|
This is because the Normalization process removes the anomalies from the data but ultimately it affects the Query performance of operations
Positive Affect: Normalization save our space by removing redundancy and anomalies and also save our record for corruption or damage. Negative Affect: It makes the DML query slow because number of joins are involved
|
|
#3
01-19-2012, 05:43 PM
|
||||
|
||||
|
Using of normalization in sql is good because.....
Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.
|
|
Linear Mode
