To create a well-formed relation through normalization, every ...

[Anajune7]

To create a well-formed relation through normalization, every determinant must be a candidate key.
 
  Indicate whether the statement is true or false

Question 2

What is denormalization and why can it be desirable?
 
  What will be an ideal response?

[paavo]

Answer to Question 1

TRUE

Answer to Question 2

Denormalization is the process of consolidating relations that are in a higher normal form into a single relation that is in a lower normal form, thereby making it susceptible to more anomalies. Denormalization can be desirable for two reasons. First, sometimes the act of normalizing a table can cause it to become too cumbersome or contrived, which makes it difficult to work with. Therefore denormalization may be preferable when the dangers of the additional anomalies are considered to be of less importance than the ease of working with the relations. Second, processing multiple tables requires more processing overhead than processing a single table. Therefore, performance can often be improved by using a single, denormalized table than multiple, normalized tables. When the performance gain outweighs the dangers of the additional anomalies, the denormalized table may be preferred.

[Anajune7]

Thank you

[paavo]

No problemo