answersLogoWhite

0

A surrogate key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.

Use a Surrogate when you do not want or need the key to have business meaning.

User Avatar

Wiki User

14y ago

What else can I help you with?

Continue Learning about Information Science

Can the FirstName column be a primary key?

A First name field is not a good one for a primary key. A primary key cannot have duplicate values. A first name field is highly likely to have duplicate values, so it should not be used as a primary key.


Which type of database model connects data in different files through the use of a key field?

The relational database model connects data through the use of a key field, which is called a primary key in one table and a foreign key in another table. This key field establishes a relationship between different tables by uniquely identifying records.


What command is used to change contents of one database using the contents of another database by linking them on a common key field?

The SQL command UPDATE can be used to change contents of one database using the contents of another database by joining them on a common key field. You would typically use a query with a join condition between the two tables based on the common key field to update the fields in the target table with values from the source table.


What do you use to classify things?

well, to classify living things scientists use a dichotomous key. A dichotomous key is a key which is sort of like a family tree, the key is split into two branches. di means 2.sometimes scientists use other keys to classify living thing. hope this helped.


What is one big message of Bloom's revised cognitive taxonomy Kendall's and Marzano's new taxonomy of objectives to teachers regarding the assessment process?

One key message is the importance of aligning assessments with the desired learning outcomes. Teachers should design assessments that match the cognitive levels being targeted in order to accurately measure student understanding. Additionally, it is crucial to use a variety of assessment methods to capture the full range of student learning.

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.


What is a key code that you can use for War Craft reign of chaos?

No one should give out their key codes in a place like this.


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.


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.


What punctuation should be used in the sentence use the blue key not the yellow key?

The sentence "Use the blue key, not the yellow key" should use a comma before the phrase "not the yellow key" to separate the two contrasting elements.


What is the correct way to punctuate you should use the blue key not the yellow?

You should use the blue key, not the yellow.


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.


Can anyone give their Microsoft Office product key?

There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.There is only one per copy of Office, so if you have Office you should have one and if you try to use someone else's then Office may not work for you. Check for the key on the packaging of your Office.


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.


How toget to The trunkwhen's 93 lincoln mark VIII when trunk is locked?

you should be able to use the button on the drivers door to pop it, if not you will have to use your key or have a key made if you dont have one


How do you use surrogate in a sentence?

The twins' hands surrogated together perfectly.