Referential Integrity
A feature provided by relational database management systems (RDBMS’s) that prevents users or applications from entering inconsistent data. Most RDBMS’s have various referential integrity rules that you can apply when you create a relationship between two tables.
For example, suppose Table B has a foreign key that points to a field in Table A. Referential integrity would prevent you from adding a record to Table B that cannot be linked to Table A. In addition, the referential integrity rules might also specify that whenever you delete a record from Table A, any records in Table B that are linked to the deleted record will also be deleted. This is called cascading delete. Finally, the referential integrity rules could specify that whenever you modify the value of a linked field in Table A, all records in Table B that are linked to it will also be modified accordingly. This is called cascading update.
Read Also:
- reference template
(n.) Also referred to as simply a template, the data in a biometric security system that represents the biometric measurement of a specific person��s identity.
- referrer
Used in Web analytics, it is the URL or IP address that tracks where a visitor to a Web page originated (e.g., previous page, link from another Web site, or search engine).
- reflection
A feature of attribute-based programming that allows an application to query its own metadata. Reflection allows an application to discover information about itself so that it may display this information to the user, modify its own behavior by using late-binding and dynamic invocation (i.e., binding to and calling methods at runtime), or create new data […]
- reflective
(adj.) A type of LCD screen in which the pixels are illuminated from in front of the monitor��s screen (the same side as the user). Reflective LCDs reflect polarized light from the environment in which they are functioning and bounces the light back to the user through the monitor. They are well-suited for bright and […]
- refresh
(1) Generally, to update something with new data. For example, some Web browsers include a refresh button that updates the currently displayed Web pages. This feature is also called reload. (2) To recharge a device with power or information. For example, dynamic RAM needs to be refreshed thousands of times per second or it will […]