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


pangili4

  • Member
  • Posts: 346
Reply 3 on: Yesterday
Gracias!

 

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Did you know?

Sildenafil (Viagra®) has two actions that may be of consequence in patients with heart disease. It can lower the blood pressure, and it can interact with nitrates. It should never be used in patients who are taking nitrates.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

Approximately 70% of expectant mothers report experiencing some symptoms of morning sickness during the first trimester of pregnancy.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

For a complete list of videos, visit our video library