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 62 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
Great answer, keep it coming :)

shailee

  • Member
  • Posts: 392
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Lyme Disease Concept Map Lyme Disease Concept Map
Gram + Cocci Concept Map Gram + Cocci Concept Map
Concept map 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
How our participation in social groups shapes our self-concept is a focus of symbolic ... How our participation in social groups shapes our self-concept is a focus of symbolic ...
The Concept of Water Balance The Concept of Water Balance
Video: Chemical Equilibrium between N2O4 (colorless gas) and NO2 (brown gas)

For a complete list of videos, visit our video library