What is a surrogate primary key, and when would you use one?

Question:

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database Systems Design Implementation and Management

ISBN: 978-1285196145

11th edition

Authors: Carlos Coronel, Steven Morris

See More Books

Question Posted: Dec 03, 2014 08:54 AM

See More Questions

What is a surrogate key, and when should you use one?
What is the Query Wizard and when would you use it?
When would you use differencing and when would you employ seasonal differencing?
A ball is dropped from a high rise platform at t = 0 starting from rest. After 6 seconds another ball is thrown downwards from the same platform with a speed v. The two balls meet at t = 18s. What is...
A firm's production function is initially Q = KL, with MPK = 0.5(L/K) and MPL = 0.5(K/L). Over time, the production function changes to Q = KL, with MPK = L and MPL = K. a) Verify that this change...
Name two ways that, as a programmer, you can improve cache performance.
Describe the ways in which business-to-business (B2B) firms segment their markets.
CVP analysis (CMA, adapted) Galaxy Disks projected operating income for 2008 is $200,000, based on a sales volume of 200,000 units. Galaxy sells disks for $16 each. Variable costs consist of the $10...
A stock price (which pays no dividends) is $50 and the strike price of a two-year European put option written on the stock is $60. The risk-free rate is 5% per annum (continuously compounded). Which...
Cassi Taxpayer (SSN 412-34-5670) who is single, has a home cleaning business she runs as a sole proprietorship. The following are the results from business operations for the tax year 2014: Gross...
Under what circumstances are composite primary keys appropriate?
When implementing a 1:1 relationship, where should you place the foreign key if one side is mandatory and one side is optional? Should the foreign key be mandatory or optional?
Draw a diagram to illustrate a decrease in exports and the change in the U.S. price level in the short run. U.S. imports are recovering thanks to the $2 trillion rescue package passed by Congress....
Home Base, Incorporated reports the following production cost information: Units produced 97,000 units Units sold 92,000 units Ending finished goods inventory 5,000 units Direct labor $17 per unit...
About New York City public sector finance. The other way is to delineate the problem. We should use data to show a problem, and then analyze the environment in which budgeting takes place to suggest,...
From a survey a company has determined that 23% of its customers are classified as "advocates" , 68% as "passives" and the remainder as "detractors" . Research suggests that during a year 15% of the...
The following are the transactions of Spotlighter, Incorporated, for the month of January. a. Borrowed $3,940 from a local bank on a note due in six months. b. Received $4,630 cash from investors and...
1. What are the deeper problems that plague in different forms it takes throughout the world according to the authors? Please, briefly explain. 2. Why was Joseph Schumpeter a pessimist about the...
$100 \div 33$ Translate from algebra to words.
Using thermodynamic data from Appendix 4, calculate G at 258C for the process: 2SO 2 (g) + O 2 (g) 88n 2SO 3 (g) where all gases are at 1.00 atm pressure. Also calculate DG8 at 258C for this same...
An electric cell has the following chemical reaction \[\mathrm{Zn}(\mathrm{s})+2 \mathrm{AgCl}(\mathrm{s})=\mathrm{ZnCl}_{2}+2 \mathrm{Ag}(\mathrm{s})\] and produces an emf of $1.005 \mathrm{~V}$...
Find the listing of customers who did not make purchases during the invoicing period. Sort the results by customer code. Your output must match the output shown in Figure P7.23. Figure P7.23 Balances...
Create a query to find the balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.22. Figure P7.22 Balance...
Provide a summary of customer balance characteristics for customers who made purchases. Include the minimum balance, maximum balance, and average balance, as shown in Figure P7.21. Figure P7.21...
Slow Roll Drum Co. is evaluating the extension of credit to a new group of customers. Although these customers will provide $198,000 in additional credit sales, 13 percent are likely to be...
Wendell's Donut Shoppe is investigating the purchase of a new $39,600 conut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings...
1.Discuss the challenges faced with Valuing Stocks and Bonds. As part of this discussion, how will the selected item be implemented in an organization and its significance? 2. Discuss how Valuing...

What is a surrogate primary key, and when would you use one?

Question:

Step by Step Answer:

A surrogate primary key is an artificial PK that is used to uniquely ide...View the full answer

Database Systems Design Implementation and Management

Students also viewed these Computer Sciences questions