This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain the concept of a surrogate key. What will be an ideal ... (Read 33 times)

Haya94

  • Hero Member
  • *****
  • Posts: 558
on: Jul 7, 2018
Explain the concept of a surrogate key.
 
  What will be an ideal response?

Question 2

An entity that must logically depend on another entity is called a(n) ________ entity.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Sassygurl126

  • Sr. Member
  • ****
  • Posts: 320
Reply #1 on: Jul 7, 2018
Answer to Question 1

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.

Answer to Question 2



Haya94

  • Member
  • Posts: 558
Reply 2 on: Jul 7, 2018
:D TYSM

vickyvicksss

  • Member
  • Posts: 351
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Photosynthesis Concept Map Photosynthesis Concept Map
This modified model of Easton’s systems theory puts government decision makers as the source of pol This modified model of Easton’s systems theory puts government decision makers as the source of pol
Biology Concept Framework Biology Concept Framework
Please fully explain in detail Please fully explain in detail
Explain how it can be desirable from an intertemporal perspective for a country run a current ... Explain how it can be desirable from an intertemporal perspective for a country run a current ...
Is my concept map correct? (Grade 12 Bio) Is my concept map correct? (Grade 12 Bio)
Video: Sex-Linked Traits! How are eye colors inherited in fruit flies?

For a complete list of videos, visit our video library