Author Question: Discuss why it is important to remove multivalued attributes from a relation. What will be an ... (Read 91 times)

aabwk4

  • Hero Member
  • *****
  • Posts: 593
Discuss why it is important to remove multivalued attributes from a relation.
 
  What will be an ideal response?

Question 2

An information system can enable a company to focus on a market niche through:
 
  A) complex trend forecasting.
  B) tailoring products to the client.
  C) intensive product trend analysis.
  D) intensive customer data analysis.
  E) tightening linkages with suppliers.


Dinolord

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

A multivalued attribute is one that can take on more than one value. According to the definition of a relation, there can be no multivalued attributes. The reason for this will be seen later when the schema is normalized. A multivalued attribute can be resolved by creating a separate instance for each value and repeating the data from the non-multivalued attributes.

Answer to Question 2

D



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

For a complete list of videos, visit our video library