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 376 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
Thanks for the timely response, appreciate it


smrtceo

  • Member
  • Posts: 344
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

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?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

For a complete list of videos, visit our video library