Top Posters
Since Sunday
25
24
23
22
22
22
22
21
21
21
21
20
New Topic  
wrote...
Posts: 97
2 months ago
Explain the pragmatic reason for using surrogate keys.
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 13 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 129
2 months ago
Sign in or Sign up in seconds to unlock everything.
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
  171 People Browsing
 141 Signed Up Today
Your Opinion

Previous poll results: Who's your favorite biologist?
Related Images
 864
 504
 662