What Is The Need Of Surrogate Key;why Primary Key Not Used As Surroga

1.	What Is The Need Of Surrogate Key;why Primary Key Not Used As Surrogate Key?
Answer» Surrogate KEY is an artificial identifier for an entity. In surrogate key values are generated by the system sequentially(Like Identity property in SQL Server and Sequence in Oracle). They do not DESCRIBE anything. Primary Key is a NATURAL identifier for an entity. In Primary KEYS all the values are entered manually by the user which are uniquely identified. There will be no repetition of data. Surrogate Key is an artificial identifier for an entity. In surrogate key values are generated by the system sequentially(Like Identity property in SQL Server and Sequence in Oracle). They do not describe anything. Primary Key is a natural identifier for an entity. In Primary keys all the values are entered manually by the user which are uniquely identified. There will be no repetition of data.

What Is The Need Of Surrogate Key;why Primary Key Not Used As Surrogate Key?

Answer»

Surrogate KEY is an artificial identifier for an entity. In surrogate key values are generated by the system sequentially(Like Identity property in SQL Server and Sequence in Oracle). They do not DESCRIBE anything. Primary Key is a NATURAL identifier for an entity. In Primary KEYS all the values are entered manually by the user which are uniquely identified. There will be no repetition of data.

Surrogate Key is an artificial identifier for an entity. In surrogate key values are generated by the system sequentially(Like Identity property in SQL Server and Sequence in Oracle). They do not describe anything. Primary Key is a natural identifier for an entity. In Primary keys all the values are entered manually by the user which are uniquely identified. There will be no repetition of data.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?