Order Now

Referential Integrity

Category:

No matching category found.

0 / 5. 0

Words: 275

Pages: 1

157

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

Bessie Ward

5,0 (374 reviews)

Recent reviews about this Writer

If you’re looking for the best academic writing service ever, you’re on the right track. My lab report is off the charts! I know this for sure beсause my professor is usually pretty picky, and he gave me an “A”!

View profile

Related Essays

Analysis of The Actor Network Theory

Pages: 5

(1375 words)

Engineering Admissions Essay

Pages: 4

(1100 words)

Occupational Therapy Program

Pages: 1

(550 words)

Nursing Informatics

Pages: 1

(275 words)

Quiz1

Pages: 3

(825 words)

Finance Admission essay

Pages: 1

(550 words)

Healthcare Quality

Pages: 6

(1650 words)

Networked Services

Pages: 8

(2200 words)

Medication Use Studies

Pages: 4

(1150 words)