answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: What is a surrogate key and when do you use one?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Types of keys?

There are many keys in database each having particular use. Types of keys in database are : Primary key, candidate key, alternate key, foreign key, surrogate key.


What are the advantage of primary key?

Primary key that is used to identify a record uniquely. Primary key is a key that always unique and not null. A system generated primary key is called surrogate key.Primary key is the one which is always unique and not null. Advantage of primary key that it helps in identifying a tuple uniquely.


How much types of keys are available in dbms?

There are five types of keys in database management system . The name of the five keys are as follows .:1) surrogate key -which is the system generated primary key .2) Primary key - same function as surrogate key but user defined.3) candidate key -combination of two more keys.4) alternate keys - alternative for candidate keys.5) foreign key - primary key of another table.There are five types of keys in database management system.These five keys are surrogate, primary, candidate, alternate, foreign keys .


Do you have to have one baby before you can be a surrogate mother?

Do you have to have a baby before you can be a surrogate mother


What is difference between natural key and surrogate key?

Surrogate Key: Surrogate keys are keys that have no "business" meaning and are solely used to identify a record in the table. Such keys are either database generated (example: Identity in SQL Server, Sequence in Oracle, Sequence/Identity in DB2 UDB etc.) or system generated values (like generated via a table in the schema). Natural Key: Keys are natural if the attribute it represents is used for identification independently of the database schema. What this basically means is that the keys are natural if people use them example: Invoice-Numbers, Tax-Ids, SSN etc.


Types of keys in database management system?

super key foreign key candidate key surrogate key unique key alternate key composite key compound key


What does surrogate shoppers mean?

A surrogate shopper could be someone who is shopping for some one else, rather than for themself. Surrogate can mean a replacement, or stand-in.


Surrogate advertisement definition?

The definition for surrogate advertising is a form of advertising that is used to promote a banned product disguised as another product. Alcohol and cigarettes are items that use surrogate advertising.


If you have Antiphospholipid Syndrome and you are wanting to use a surrogate mother can you pass it on to the surrogate mother?

No, you cannot pass Antiphospholipid syndrome to a surrogate mother who is carrying your baby. You can pass it onto your unborn baby though.


Why would a person use a surrogate?

When a couple attempts to have a child but cannot for various reason they may want to obtain the services of a surrogate. All states now allow couples to obtain the services of a surrogate. The surrogate will carry the couple's baby to full term for a fee.


What is the use of surrogate in GC?

The surrogate you put into your pre clean-up sample. It is at a known concentration, so that you will be able to calculate % recovery after the run.


How do you use surrogate in a sentence?

The twins' hands surrogated together perfectly.