What are the advantages and disadvantages of normalization? ...

[luminitza]

What are the advantages and disadvantages of normalization?
 
  What will be an ideal response?

Question 2

SQL views are not used ________.
 
  A) to hide columns
  B) to show results of computed columns
  C) to hide complicated SQL statements
  D) to enforce primary key constraints

[Ashley I]

Answer to Question 1

The advantages of normalization are that it (1 ) eliminates modification anomalies and (2 ) reduces duplicated data. Reducing duplicated data will eliminate data integrity problems and save file space. The disadvantages of normalization are that it (1 ) will require application developers to write more complicated SQL statements for multitable subqueries and joins, and (2 ) may slow down the applications running against the database.

Answer to Question 2

D