Top Posters
Since Sunday
36
35
33
32
30
30
30
30
28
28
28
27
New Topic  
wrote...
Posts: 95
Rep: 8 0
2 months ago
Explain the concept of a surrogate key.
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 6 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 127
2 months ago
Sign in or Sign up in seconds to unlock everything.
A surrogate key is an artificial key that is created to act as the primary key for a relation. The surrogate key is a unique, numeric value that is appended to the relation. Surrogate keys are used in situations when no suitable primary key exists within the user data, or when all available primary keys within the data are too cumbersome for an efficient design. Surrogate key values have no meaning to the users and are normally hidden on all forms, reports, and displays. Most DBMS products can automatically generate values for surrogate keys as needed.
1
Related Topics
wrote...
2 months ago
Thanks
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
  272 People Browsing
Your Opinion
What percentage of nature vs. nurture dictates human intelligence?
Votes: 70

Related Images
 1122
 299
 2037