Database Concepts

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

Chapter 2 - The Relational Model - Review Questions - Page 107: 2.11

Answer

Define the term nonunique key and give an example. A nonunique key not only identifies a row, but it potentially identifies more than one row. In the above example, we discussed the table: EXAMPLE: TEXTBOOK (ISBN, Title, Publisher, Copyright) In this case, a nonunique key would be Publisher. Many books are tied to the same publisher, so it cannot uniquely identify a row, and could be related to many rows in the table.

Work Step by Step

N/A
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.