Database Concepts

Published by Pearson
ISBN 10: 0133544621
ISBN 13: 978-0-13354-462-6

Chapter 2 - The Relational Model - Exercises - Page 108: 2.40A

Answer

Multivalue Problem means If there exist multiple values of an Attribute.Multi column Problem occurs If there exist more than one columns that should be merged into single one.Multi Valued dependency occurs when there exist more than one value of an Attribute against a determinant and the Relation has at least three columns let say there are three columns A ,B ,C If determinant A has multiple values of B against it , B and C should be Independent From each another then there exist multi valued dependency A->->B. In the Case of the Relation Student there exist following multi valued dependencies. StudentNumber ->-> SiblingName StudentName ->-> SiblingName.

Work Step by Step

No steps
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.