Explain the concept of a surrogate key
What will be an ideal response?
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 have the ability to automatically generate values for surrogate keys as needed.
You might also like to view...
Which of the following is NOT true regarding the Internet and the practice of public relations?
A) Media professionals do not trust online information because it cannot be verified. B) The Internet is a great potential repository of education-based information. C) Many public relations firms employ interactive specialists and groups. D) Many public relations firms specialize in online communications.
In the percent of sales method, a company's asset requirements are based on the company's
projected sales level. Indicate whether the statement is true or false