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 71 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 :)

xthemafja

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

« previous next »
 

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

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

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

The strongest synthetic topical retinoid drug available, tazarotene, is used to treat sun-damaged skin, acne, and psoriasis.

Breathing Concept Map Breathing Concept Map
Concept map Concept map
Cultures Ideal Body Types Cultures Ideal Body Types
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Biology Concept Framework Biology Concept Framework
For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately
Video: Stimulus (introduction)

For a complete list of videos, visit our video library