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

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


Step by Step Solution

★★★★★

3.46 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Surrogate keys a... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database Concepts Questions!

Q:

Describe two disadvantages of surrogate keys.

Q:

Identify two examples of natural and surrogate keys in the property sales DM and discuss the benefits associated with using surrogate keys in general.

Q:

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...

Q:

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

Q:

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

Q:

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Q:

Bacteria and other microbes can be used to "clean up" an oil spill by breaking down oil into carbon dioxide and water. Two samples isolated from the Deepwater Horizon leak in the Gulf of Mexico were...

Q:

1. (TCO 2) To create a relationship between two tables, you need at least a (Points : 4) data type. query. hyperlink. primary key. 2. (TCO 2) Which of the following does NOT describe a many-to-many...

Q:

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

Bayshore Trust granted a loan to Assam based on a mortgage for $210 000 with interest at 14 percent for a one-year term. The monthly payment was $2540. At the end of the term, Bayshore renewed the...

Q:

If rates of decomposition are higher in ecosystems with higher nutrient availability, how should nutrient enrichment affect rates of decomposition? Because of its effects on fungal diversity, could...

Q:

If Corporation X borrows $ 5 million dollars from a group of banks participating in the loan and used land as collateral this type of loan is known as _ _ _ _ _ _ _ _ _ _ . Answer an asset backed...

Q:

1.4. Four firms located at different points on a river dump various quantities of effluent into it. The effluent adversely affects the quality of swimming for homeowners who live downstream. These...

Q:

Describe statement-level consistency.

Q:

Explain the meaning of the expression ACID transaction.

Q:

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...

Q:

Perform an Even Swap Analysis for the online commerce sites below. Use the following criteria to make swaps 1) As we raise the defect percent by 1%, we reduce costs by $20 2) If we raise service from...

Q:

You wish to retire in 12 years, at which time you want to have accumulated enough money to receive an annual annuity of $15,000 for 17 years after retirement. During the period before retirement you...

Q:

pls help with these asap! will give good rating! (Estimated time allowance: 20 minutes) CePina Company currently does not use any debt at all (it is an all-equity firm). The firm has 3,000,000 shares...