Introduction of the term surrogate key

Give a brief introduction of the term surrogate key?

E

Expert

Verified

A surrogate key is a distinctive identifier in the database either for an entity in the modeled object or word in the database. Application data is not employed to get surrogate key. Surrogate key is within generated key through the current system and is imperceptible to the user. As numerous objects are accessible in the database corresponding to surrogate, surrogate key cannot be used as primary key.

   Related Questions in Database Management System

┬ęTutorsGlobe All rights reserved 2022-2023.