« previous next »

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

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Advantages and disadvantages of select temperature measurement sites Advantages and disadvantages of select temperature measurement sites
Research Methods: Advantages and Limitations Research Methods: Advantages and Limitations
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
Advantages of Observational Method Advantages of Observational Method
Video: Basic rhythm - control centers in medulla oblongata, spirograph and normal tidal cycle

For a complete list of videos, visit our video library