RI meaning in Database Management ?

Answer: What is Referential Integrity mean?

Referential integrity is a property of data stating that all its references are valid. In the context of relational databases, it requires that if a value of one attribute (column) of a relation (table) references a value of another attribute (either in the same or a different relation), then the referenced value must exist.

For referential integrity to hold in a relational database, any column in a base table that is declared a foreign key can only contain either null values or values from a parent table's primary key or a candidate key. In other words, when a foreign key value is used it must reference a valid, existing primary key in the parent table. For instance, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity. Some relational database management systems (RDBMS) can enforce referential integrity, normally either by deleting the foreign key rows as well to maintain integrity, or by returning an error and not performing the delete. Which method is used may be determined by a referential integrity constraint defined in a data dictionary.

The adjective 'referential' describes the action that a foreign key performs, 'referring' to a linked column in another table. In simple terms, 'referential integrity' guarantees that the target 'referred' to will be found. A lack of referential integrity in a database can lead relational databases to return incomplete data, usually with no indication of an error.

reference

Full Form	Category
Recitation Instructor	Academic & Science
Research Institute	Academic & Science
Royal Institution of Great Britain	Academic & Science
Retention Interval	Academic & Science
Research Interviewer	Academic & Science
Rational Integral	Academic & Science
Residual Income	Accounts and Finance
Real Interest	Accounts and Finance
Ruby Tuesday, Inc.	Business
Recording Industry	Business
Redline Imports	Business
Radical Initiator	Chemistry
Retarded Institution	Community
Rehabilitation International	Community
Relief International	Community
Rapid Insert	Computer Assembly Language
Return Index	Computer Assembly Language
Register I	Computer Assembly Language
Reference Implementation	Computer Technology
Remote Intersepter	Computing
Routing Instance	Computing
Referential Integrity	Database Management
Lotus 1-2-3 Data	File Type
Randomly Initialized	General
Rule Induction	General
Ringlet Identifier	General
Region I	General
Refractive Index	General
Right Indication	General
Ruben Israel	General
Retrograde Inversion	General
Run In	General
Random Index	General
Royalty Interest	General
Renderman Interface	General
Rotary International	General
Related Injury	General
Randomly Inversed	General
Referral Interviews	General
Relative Inverse	General
Regina Imperatrix	General
Relative Intensity	General
Raw Indication	General
Remote Influencing	General
Repubblica Italiana	General
Radically Inert	General
Rotation Invariant	General
Rim Intensity	General
R Or I	General
Repec Index	General
Rate Information	General
Red Inner	General
Replaceable Item	General
Rock Island	General
Reporting Information	General
Ruby Interactive	General
Reference Intake	General
Render Interface	General
RI is	General
Retention Index	General
Rigorous Imprisonment	General
Read Intensive	General
Reproductive Isolation	General
Restricted Issue	General
Repulsion Induction	General
Ring It	General
Ramblin Irishman	General
Routing Identifier	General
Reporting Identifier	General
Relief Intensity	General
RF Interonics	Governmental
Round Island	Governmental
Rutherford Institute	Governmental
Rear Impact	Governmental
Rapist Institution	Governmental
Rule of Interpretation	Governmental
Resolution of Identity	Governmental
Rights Issue	Governmental
Reserve Index	Governmental
Raffles Institution	Governmental
Readership Institute	Governmental
Resguardo Indígena	International
Rex Ipse	International
Regina Imperiatrix	International
Rex Imperator	International
Relaciones Industriales	International
Rieti (Provence)	International
Republik Indonesia	International
Revista de Istorie	International
Rosenbluth International	International
Respiratory Infection	Medical
Respiratory Illness	Medical
Recurrence Interval	Medical
Resistive Index	Medical
Renal Insufficiency	Medical
Rather Interesting	Messaging
Rambling Irishman	Messaging
Random Insanity	Messaging
Radio Intercept	Military and Defence
Routing Indicator	Military and Defence
Radiation Intensity	Military and Defence
Refugees International	Military and Defence
Relative Interior	Real Estate
Rhode Island	Regional
Republic Of Indonesia	Regional
The Republic of Ireland	Regional
Chicago, Rock Island and Pacific Railroad	Regional
Re-installing	Softwares
Rollback Info	Softwares
Rockwell International	Space Science
Rest Interval	Sports
Receiver Induced	Telecommunication
Ring Indicator	Telecommunication
Ring In	Telecommunication