« previous next »

Author Question: What are the advantages and disadvantages of normalization? What will be an ideal ... (Read 27 times)

luminitza

  • Hero Member
  • *****
  • Posts: 555
on: Jul 7, 2018
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

  • Sr. Member
  • ****
  • Posts: 344
Reply #1 on: Jul 7, 2018
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


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

Research Methods: Advantages and Limitations Research Methods: Advantages and Limitations
Many former slaves understood that illiteracy was an implement of bondage. The Freedmen’s Bureau bui Many former slaves understood that illiteracy was an implement of bondage. The Freedmen’s Bureau bui
Advantages and Disadvantages of Managed Care Advantages and Disadvantages of Managed Care
Cultures Ideal Body Types Cultures Ideal Body Types
Routes of Drug Administration: Advantages and Disadvantages Routes of Drug Administration: Advantages and Disadvantages
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
Video: Methods of carbon dioxide transport - carbaminohemoglobin and bicarbonate ions

For a complete list of videos, visit our video library