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...
Not-for-Profit Hospital Financial Statement Analysis. Examine the financial statements for Oak Valley Hospital for the years ended December 31, 2010, and 2011. Required Prepare a short answer to...
An 80-kg man rides in an elevator from the ground to an upper floor. The elevator goes from rest to \(10 \mathrm{~m} / \mathrm{s}\) in 5 seconds, and then continues at the same constant speed for 10...
Flexible-budget variances, review of Chapters. David James is a cost accountant and business analyst for Doorknob Design Company (DDC), which manufactures expensive brass doorknobs. DDC uses two...
what happens when ou use an aggregation function in a calculated column?
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
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?
How might the following management theories/ approaches be useful to Starbucks: scientific management, organizational behavior, quantitative approach, systems approach?
CEOs pay is typically linked to the size of their firms. Some argue that CEOs have an inherent bias in favor of undertaking M&As using shareholders money. Do you agree or disagree with this view?
First reported in 1976 in Sudan and Zaire (now called the Democratic Republic of the Congo [DRC]), Ebola has been a known virus for more than four decades. Yet, there is still no effective vaccine or...
The estimated variance based on 4 measurements of a spring tension was .25 g. The mean was 37 g. Test the hypothesis that the true value is 35 g. Use = .10 and H 1 : > 35.
If your country has competition or antitrust laws, find a landmark case, and explain whether you support the plaintiff or the defendant. If your country does not have competition or antitrust laws,...
An advertisement for a brand-name camera stated that the cameras are inspected and that 60 % are rejected for the slightest imperfections. To test this assertion, you observe the inspection of a...
A furnace used to heat a home is rated at 30 kW. Determine its rating in: a. Btu/hr b. MBH
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...
Use Pohlig-Hellman algorithm to compute log2 (19) modulo 37. Compute xi's directly, by computing sufficiently many powers of gi.
A shoe seller sold shoes worth 1 6 0 TL on the first day, 1 9 2 TL on the second day and 1 4 4 TL on the third day at the some price . At was t how many shoes were sold by the seller in 3 days?
The Financial Services is one of the important industries when KPMG operates in. What's the market structure of the Financial Services?. In addition, what's the level of concentration and barriers to...

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