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 68 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
YES! Correct, THANKS for helping me on my review

Dinolord

  • Member
  • Posts: 313
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

Breathing Concept Map Breathing Concept Map
concept map : atoms and molecules concept map : atoms and molecules
Concept map for jacob's awareness Concept map for jacob's awareness
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
Historian James Merrell notes several errors in Benjamin West’s famous 1771 painting, William Penn’s Historian James Merrell notes several errors in Benjamin West’s famous 1771 painting, William Penn’s
What are examples of ideal forms? What are examples of ideal forms?
Video: Major Elements in Biological Molecules: Carbohydrates

For a complete list of videos, visit our video library