« previous next »

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

aabwk4

  • Hero Member
  • *****
  • Posts: 593
on: Jul 7, 2018
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.
Essentials of MIS ¦ Laudon, Laudon ¦ 12th Edition
Buy Test-Bank


Dinolord

  • Sr. Member
  • ****
  • Posts: 313
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

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?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Important Human Viral Table Important Human Viral Table
This chart illustrates the “drip down” model of government. In this, politics is formed by the soc This chart illustrates the “drip down” model of government. In this, politics is formed by the soc
Inverse Relation Between IQ and Disease. Could this explain the Flynn effect? Inverse Relation Between IQ and Disease. Could this explain the Flynn effect?
The camshaft is rotated in relation to the camshaft by the PCM to provide changes in valve timing. The camshaft is rotated in relation to the camshaft by the PCM to provide changes in valve timing.
How to find the maximum and minimum of a quadratic relation How to find the maximum and minimum of a quadratic relation
Calculation of the Value of Depletion for the 14 Most Important Minerals Calculation of the Value of Depletion for the 14 Most Important Minerals
Video: Double Vacuum Process (Illustration No Audio)

For a complete list of videos, visit our video library