Why are the values of surrogate keys normally hidden from users on forms, queries, and reports?

Question:

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

Step by Step Answer:

Related Book For answer-question

Database Concepts

ISBN: 978-0133544626

7th edition

Authors: David M. Kroenke, David J. Auer

See More Books

Question Posted: Jan 09, 2019 05:58 AM

See More Questions

Describe two disadvantages of surrogate keys.
Identify two examples of natural and surrogate keys in the property sales DM and discuss the benefits associated with using surrogate keys in general.
Examine the dimensional model (star schema) shown in Figure 32.13. This model describes part of a database that will provide decision support for a taxi company called FastCabs. This company provides...
The following is information for a perfectly price discriminating monopolist. Demand: P = 65 0.02Q Marginal revenue = P = 65 0.04Q Marginal cost = ATC = 4 Calculate the producer surplus for the...
For each of the following, indicate (a) If the account is an asset, liability, or owner's equity account; and (b) Whether you would use a debit or credit to record the change: 1. Increase in D....
The force generated by a spring is given by F = kx, where k is the spring constant and x is the deflection of the spring. The spring of Fig. P199 has a spring constant of 8 kN/cm. The pressures are P...
After seven years of decreasing and steadily low interest rates, the Federal Reserve Bank decided in December 2015 to make a policy change and increase the Federal Fund Rate. Assuming that all other...
The Firm Chair Company manufactures customized wood furniture and sells the furniture in large quantities to major furniture retailers. Jim Bolling has recently been assigned to analyze the companys...
A 30-year-old woman comes into the emergency department with a temperature of 39.4C (103F). For the last 4 days she has had a productive cough and has experienced dyspnea increasing in severity. Her...
The Eastclock Corporation (EC) manufactures timing devices that are used in industrial settings. Recently, profits have fallen, and management is seeking your advice as an outside consultant on...
Explain how primary keys and foreign keys are denoted in this book.
Estimate the energy of a Boeing 747 (mass M=400 t) at cruising speed (850 km h -1 ) and compare it with the energy released in a mosquitoantimosquito annihilation.
You believe that the future value of the Australian dollar will be determined by purchasing power parity (PPP). You expect that inflation in Australia will be 6% next year, whereas inflation in the...
Lead and manage effective workplace relationships Develop cultural diversity and ethical practice policies and include them with your assessment. Your policies should demonstrate a recognition of the...
Wal-Mart, BJ Wholesale, and Sam's Club are Costco's top competitors. Headquartered in Bentonville, Arkansas, Sam's Club operates in the retail distributors industry and generates $90billion less...
Onto, and one-to-one functions Hamming distance In computer science, the hamming distance (named after Richard Hamming) is a function used to count the number of flipped bits in a fixed-length binary...
Tony Stark has hired as you an implementation consultant to oversee the implementation and rollout of Binary Augmented Retro Framing (BARF) to replace an obsolete VR training system for SHIELD. The...
At a level of 7 , 8 5 8 units, Lydia, Inc., a company that makes shovels, has total fixed costs of $ 3 5 9 , 4 3 1 and total variable costs of $ 3 3 6 , 0 5 6 for delivery. What would the total...
If a bank is very uncertain about future interest rates, how might it insulate its future performance from future interest rate movements?
Refer to the data in QS 10-1. Based on financial considerations alone, should Helix accept this order at the special price? Explain.
Describe statement-level consistency.
Explain the meaning of the expression ACID transaction.
What is SQL Transaction Control Language (TCL)? Explain the use of SQL BEGIN TRANSACTION, COMMIT TRANSACTION, and ROLLBACK TRANSACTION statements. Why does MySQL also use the SQL START TRANSACTION...
81. If push-down accounting is used, what amounts in the Building account appear on Duchess separate balance sheet and on the consolidated balance sheet immediately after acquisition? 82. If...
A Ltd. obtained from B. S. Ltd. a lease of some coal bearing land, the terms being a royalty of ~ 15 per ton of coal raised subject to minimum rent of ~ 75,000 per annum with a right of recoupment of...
The Linux kernel is the largest component of the Linux operating system and is charged with managing the hardware, running user programs, and maintaining the security and integrity of the whole...

Why are the values of surrogate keys normally hidden from users on forms, queries, and reports?

Question:

Step by Step Answer:

Surrogate keys a...View the full answer

Database Concepts

Students also viewed these Computer science questions