Ask a Question
  
  
  
Top Posters
Since Sunday
21
15
7
7
6
6
6
5
5
5
5
5
New Topic  
wrote...
Posts: 38
Rep: 7 0
A week ago
Explain the pragmatic reason for using surrogate keys.
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 8 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 29
Rep: 6 0
A week ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
Primary keys are commonly included in indexes, and are used to identify records to be retrieved by users. The ideal primary key is short, numeric and fixed. When the primary key contains a lengthy text field, this creates a large amount of duplicated data that must be frequently manipulated. For these reasons, it is often practical to use a surrogate key that is generated by the system and is relatively small and easy to manipulate.
Related Topics
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  86 People Browsing
 130 Signed Up Today
Related Images
 119
 114
 100
Your Opinion