Order Now

Referential Integrity

Category:

No matching category found.

0 / 5. 0

Words: 275

Pages: 1

120

Referential Integrity
Author
Institution

Referential Integrity
Referential integrity refers to the use of relationships to achieve consistency and accuracy in databases; the relationships help in joining two or more tables, this is accomplished by establishing a primary key that is used in the parent table and foreign keys that are used in the associated sub-tables (Database Guide, 2016). The keys are unique for every record entered into the database. Referential integrity, therefore, allows the users in charge of feeding information into systems to add data without creating unnecessary duplicates.
An example of a situation that is analogous to referential integrity is the storing of records in institutions such as hospitals at separate points without any connections between them despite them being related. In such a case, there exists no primary key that allows people collecting information from the patients to identify whether data about a person has been entered into the system or not. Since there are several points in hospitals where data on the patients are collected such as the reception and information recorded by different doctors, it is possible to enter several copies of related data about the same person; this results in redundancy. If referential integrated were implemented in such a situation, the patients would be assigned a primary key at the reception, and other doctors can add to their information with the help of foreign keys.
Some of the main advantages of referential integrity include the provision of a mechanism that prevents the creation of unnecessary duplicates, prevention of records from pointing to non-existence fields in other files, guaranteeing consistency of the sub-tables with the main tables and prevention of accidental deletion of information that is still required in other areas (Chapple, 2018).

Wait! Referential Integrity paper is just an example!

Despite the many of advantages of referential integrity, one of the cons is that complex hierarchies employed in the technique might negatively affect the performance of the database systems, processes such as deletions might require erasing data from several tables; it might, therefore, take slightly longer before the process completes.

References
Chapple, M. (2018). How Referential Integrity Ensures Database Consistency. Lifewire. Retrieved from https://www.lifewire.com/referential-integrity-definition-1019181Database Guide. (2016). What is Referential Integrity? Database.Guide. Retrieved from https://database.guide/what-is-referential-integrity/

Get quality help now

Oscar Gilmore

5,0 (576 reviews)

Recent reviews about this Writer

My classmates always envy me and ask me how I can be so smart to receive the best grades in the class. Well, we know the secret. I’m happy to have this company as an assistant and even a friend.

View profile

Related Essays

ADD/ADHD

Pages: 1

(275 words)

Any pediatric disorder

Pages: 6

(1650 words)

Foundations of Islam

Pages: 1

(275 words)

land law

Pages: 7

(1925 words)

Columbas

Pages: 3

(825 words)

Hazard Mitigation

Pages: 4

(1100 words)

Employee Motivation

Pages: 3

(825 words)

CV and Project List

Pages: 5

(1375 words)