Database Concepts

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

Chapter 2 - The Relational Model - Review Questions: 2.10

Answer

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

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.