« previous next »

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

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Advantages and disadvantages of select temperature measurement sites Advantages and disadvantages of select temperature measurement sites
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
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: Activation Energy - Valence Electrons

For a complete list of videos, visit our video library