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 78 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


sailorcrescent

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

 

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

Did you know?

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

For a complete list of videos, visit our video library