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

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

For a complete list of videos, visit our video library