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

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

For a complete list of videos, visit our video library