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...
Of the internal stakeholders, the group that is the most critical to the success of a firm would be:
A) shareholders B) employees C) the labor union D) customers
Which of the following best explains the goal of neuromarketing?
A) using subliminal messages to influence consumer decisions B) collecting data about responses to advertising and products by scanning consumers' brains C) observing and tracking consumer behavior on the Internet D) designing marketing research experiments using the Internet E) analyzing data from various sources to answer complex "what if" questions
A successful campaign to organize commercial building janitors in several major cities during the 1980s was known as the _______________________________ campaign.
Fill in the blank(s) with the appropriate word(s).
Which of the following parties can defeat a perfected security interest?
a. A "buyer in ordinary course of business." b. A buyer of consumer goods if the buyer is not aware of the security interest, gives value for the goods, will continue to use the goods as consumer goods, and the secured party has not filed a financing statement. c. A buyer who purchases chattel paper or an instrument in the ordinary course of business, and then takes possession. d. All of the above are correct.