Discuss why it is important to remove multivalued attributes from ...

[aabwk4]

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]

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