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

Author Question: Explain the essence of normalization that is implemented through the use of normal forms. What ... (Read 75 times)

bobypop

  • Hero Member
  • *****
  • Posts: 539
Explain the essence of normalization that is implemented through the use of normal forms.
 
  What will be an ideal response?

Question 2

Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance), write the standard SQL query to retrieve the Name and PhoneNumber of customers with a balance greater than 50.
 
  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

tandmlomax84

  • Sr. Member
  • ****
  • Posts: 323
Answer to Question 1

The essence of normalization is to create relations that contain data on a single theme, and for each row in a relation to contain all the data about that theme for a given entity. This essence is implemented in the normal forms by taking a relation that contains data on more than one theme and splitting it into multiple relations that each contains data on a single theme. The different normal forms protect against the occurrence of modification anomalies. In practice, making sure all relations are in Boyce-Codd Normal Form (BCNF), or in Fourth Normal Form (4NF) if multivalued dependencies are found, insures high reliability of the database.

Answer to Question 2

SELECT Name, PhoneNumber
FROM CUSTOMER
WHERE AccountBalance > 50;




bobypop

  • Member
  • Posts: 539
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review


tanna.moeller

  • Member
  • Posts: 328
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

For a complete list of videos, visit our video library