5 Jul 2022


Choosing a Primary Key: Natural or Surrogate?

Format: APA

Academic level: College

Paper type: Coursework

Words: 325

Pages: 1

Downloads: 0

Choosing the primary key for a table is very critical as it is the most important steps in database design. This is because keys play an important role in maintaining a database in a more consistent manner. There are two types of primary keys; natural and surrogate key architectures. This paper discusses the two types of keys, their advantages, and disadvantages. 

The natural key is also known as the intelligent or the domain key. The key is logically related to the table, which means, the key is always in a single column hence identifying records in a table which are made of real data. Some of the examples of natural keys are Social Security Number and Tax Id. Surrogate keys, on the other hand, have only a singleton attribute. Their values are entirely numeric, system generated and lastly used in the identifications of tuples in relations ( Link, Luković & Mogin , 2010). 

It’s time to jumpstart your paper!

Delegate your assignment to our experts and they will do the rest.

Get custom essay

There are various pros and cons of using both keys in a database. The main advantage of natural keys is the fact that they are well arranged and exist in a schema. Therefore, there would be no need for additional columns in the loading of tables. Besides, they are very easy to search for each natural key had its meaning in the database. The disadvantage with this type of key is that it requires a lot of work especially in making amendments when foreign relationships are built 

The advantage of the surrogate keys is that they do not have business intelligence built on them. This means that no one can derive meaning and the relationship in a database as compared to the natural keys. Moreover, they have better performance as compared to the physical keys as they are typically integers. This implies that they require smaller storage hence a small index structure making the performance more effective. On the cons, surrogate keys are not very useful, especially when searching for data as they have no meaning and knowledge an important aspect that is considered in the interaction of elements in the database. 


Link, S., Luković, I., & Mogin, P. (2010). Performance evaluation of natural and surrogate key database architectures . School of Engineering and Computer Science, Victoria University of Wellington. 

Cite this page

Select style:


StudyBounty. (2023, September 15). Choosing a Primary Key: Natural or Surrogate?.


Related essays

We post free essay examples for college on a regular basis. Stay in the know!

Security Implication of the Internet of Things

The Internet of Things (IoT) can be described as s system of interconnected devices that have the ability to transfer information over a computer network without the need of human-to-computer or human-to-human...

Words: 892

Pages: 3

Views: 96

Modern Day Attacks Against Firewalls and VPNs

Introduction The need to have an enhanced security of the computer connectivity happens to be one of the reasons that attract companies and organizations towards wide usage of VPNs. Several simple techniques...

Words: 2025

Pages: 7

Views: 134

How to Deploy and Administer Windows Server 2012

Securing a reliable, and expandable configuration for a company is important to build a strong network. The new and enhanced features of the Windows Server 2012 can be used to implement the network. In this...

Words: 1673

Pages: 6

Views: 87

Deployment Model in Cloud Computing

Deployment model is a representation of a cloud environment primarily distinguished by parameters such as accessibility, proprietorship, and storage size. The National Institute of Standards and Technology gives the...

Words: 254

Pages: 1

Views: 81

How to Use Web Search Engines for Business Research

The advancement of technology has made it possible for many people around the world to have easy access to information whenever they want. The development of the Wide World Web-enabled different kinds of information...

Words: 773

Pages: 3

Views: 86

Distributed Database Management System (DDBMS)

Introduction Data management has been a headache to many technology enthusiasts for quite a long period of time. They have successfully managed to logically collect interrelated data and share it. If the data is...

Words: 799

Pages: 3

Views: 127


Running out of time?

Entrust your assignment to proficient writers and receive TOP-quality paper before the deadline is over.