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


AISCAMPING

  • Member
  • Posts: 347
Reply 3 on: Yesterday
Excellent

 

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

For a complete list of videos, visit our video library