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.10


Define the term unique key and give an example. In databases, a unique key is a column whose values identify one and only one row. People in the United States have a unique key that identifies them: their Social Security number. Everyone has a unique Social Security number which relates only to them, does not change, and is not assigned to anyone else. Another example is books, which have a unique key that identifies them: their ISBN number. Example: TEXTBOOK (ISBN, Title, Publisher, Copyright) In this row, the ISBN number is a unique key which identifies only one particular book.

Work Step by Step

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.