Author Question: Discuss why it is important to remove multivalued attributes from a relation. What will be an ... (Read 83 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?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

Atropine, along with scopolamine and hyoscyamine, is found in the Datura stramonium plant, which gives hallucinogenic effects and is also known as locoweed.

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

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?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

For a complete list of videos, visit our video library