Author Question: What are some of the problems with arrays or repeated groups in a database? What will be an ideal ... (Read 106 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?

Russia has the highest death rate from cardiovascular disease followed by the Ukraine, Romania, Hungary, and Poland.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

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?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

For a complete list of videos, visit our video library