Author Question: What are some of the problems with arrays or repeated groups in a database? What will be an ideal ... (Read 105 times)

gbarreiro

  • Hero Member
  • *****
  • Posts: 566
What are some of the problems with arrays or repeated groups in a database?
 
  What will be an ideal response?

Question 2

An analyst may develop the data flow diagram using a top-down method by using:
 
  A) algebraic notation.
  B) structural records.
  C) algebraic notation and structural records.
  D) vertical expansion methodology.



billybob123

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

When there is an array or a repeated group in a database entity, it is difficult to retrieve data. With an array, the only way to retrieve a specific value from the column is to use some sort of string function to extract it from the list. With a repeated group, the user has no idea which column of the group will contain the value he or she wants, so they will have to query all the columns in the group. Groups also lack flexibility. Say you have three columns in a group. If there are only two values then one of the columns must remain null; if there are four values, there is nowhere to store the fourth one.

Answer to Question 2

C



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

For a complete list of videos, visit our video library