Match each of the following to Natural or Surrogate to indicate which type of primary key would be appropriate: Transaction Number Email Address Username Social Security Number UUID
Added by Keith B.
Step 1
- Natural keys are unique attributes inherent in the data itself, such as a person's Social Security Number or an email address. - Surrogate keys are artificial keys assigned by the database to uniquely identify each record, such as a Transaction Number or a UUID. Show more…
Show all steps
Your feedback will help us improve your experience
Rashmi Sinha and 69 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Explain three conditions that suggest a surrogate key should be created for the primary key of a relation.
b) Map the BANK ER schema shown in Figure 3.22 into a relational schema. Specify all primary keys and foreign keys.
Akash M.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD