Ask a Question
  
  
  
Top Posters
Since Sunday
21
15
7
7
6
6
6
5
5
5
5
5
New Topic  
wrote...
Posts: 28
Rep: 7 0
A week ago
What is the multivalue, multicolumn problem, and why is it a problem? Include an example.
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 7 times
3 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 21
Rep: 2 0
A week ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
The multivalue, multicolumn problem occurs when a table uses multiple columns to store multiple values of an attribute. For example, a database of dog owners might have a table with the structure:

DOG_OWNER (OwnerID, LastName, FirstName, DogName01, DogName02, DogName03)

This is a problem because (1) the number of DogNames is fixed, and (2) this structure creates query problems. In fact, this structure is another form of the multivalued dependency, and requires a similar solution: a DOG table should be created to store the DogNames and with a foreign key to link the dogs to their owner.
1
Related Topics
wrote...
A week ago
TY
wrote...
A week ago
Welcome Slight Smile
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  89 People Browsing
 131 Signed Up Today
Related Images
 1085
 67
 59
Your Opinion
Who's your favorite biologist?
Votes: 13