« previous next »

Author Question: What are the advantages and disadvantages of normalization? What will be an ideal ... (Read 50 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?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

The familiar sounds of your heart are made by the heart's valves as they open and close.

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

Cultures Ideal Body Types Cultures Ideal Body Types
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Advantages and Disadvantages of Convection super-heater Advantages and Disadvantages of Convection super-heater
Advantages and DisAdvantages of Radiant super-heater Advantages and DisAdvantages of Radiant super-heater
Routes of Drug Administration: Advantages and Disadvantages Routes of Drug Administration: Advantages and Disadvantages
For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately
Video: Role of the respiratory system - effect of altered ventilation rates

For a complete list of videos, visit our video library