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

Author Question: Explain First Normal Form and provide examples. What will be an ideal ... (Read 291 times)

Tirant22

  • Hero Member
  • *****
  • Posts: 532
Explain First Normal Form and provide examples.
 
  What will be an ideal response?

Question 2

The symbol X(8 ) represents:
 
  A) eight digits.
  B) eight alphanumeric characters.
  C) a data structure or element that repeats eight times.
  D) an element that is found within eight data structures.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

soda0602

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

The First Normal Form removes repeating groups and arrays. If a column in a Customer table, for example, contained multiple phone numbers, that would be an array. If it contained multiple columns named something like Phone1, Phone2, etc., that would be a repeating group. To make the table conform to First Normal Form the phone numbers should be placed in another entity with a relation to the Customer entity.

Answer to Question 2

B




Tirant22

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


mochi09

  • Member
  • Posts: 335
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Chronic marijuana use can damage the white blood cells and reduce the immune system's ability to respond to disease by as much as 40%. Without a strong immune system, the body is vulnerable to all kinds of degenerative and infectious diseases.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

For a complete list of videos, visit our video library