answersLogoWhite

0

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.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is a surrogate key and when should you use one?

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.


What is the difference between a key and a legend?

There is no difference.


What is an artificial key?

An artificial key is a surrogate key, often an auto-incremented numeric value, used to uniquely identify records in a database when a natural key is not available or appropriate. Artificial keys are generated and managed by the database system, providing a simple and efficient way to uniquely identify records.


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 .


What was a key difference between the ideas of Hobbes and Locke?

A key difference between Hobbes and Locke is their views on the nature of human beings. Hobbes believed that humans are inherently selfish and need a strong government to maintain order, while Locke believed that humans are inherently rational and have natural rights that should be protected by a limited government.


What is the key difference between a liquid a gas?

intermolecular attractions


What is the key difference between a gas and liquid?

intermolecular attractions


What is the key difference between a liquid and a gas answer?

A is expanded in a container.


What is a key difference between a liquid and a gas?

intermolecular attractions


What is the difference between a key deer and a deer?

key deer are smaller than regular deer


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.


Types of keys in database management system?

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