This topic contains a solution. Click here to go to the answer

Author Question: To create a well-formed relation through normalization, every determinant must be a candidate key. ... (Read 117 times)

Anajune7

  • Hero Member
  • *****
  • Posts: 574
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?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

paavo

  • Sr. Member
  • ****
  • Posts: 301
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.





 

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

For a complete list of videos, visit our video library