The Relavance Of Referential Integrity
The Relevance of Referential Integrity
Databases are the core of Information Systems. Without databases, there would be no place to store valuable data that needs to be retrieved at any given time. There is a necessity to ensure the quality of a database in order to ensure the quality of the information system. To ensure the quality of a system, referential integrity must be in place to control the data. This facility maintains relationships between data and protecting data integrity.
What is Referential Integrity?
The relational model enforces referential integrity. That means one must enable the system referential integrity feature to meet relational rules. This can be as simple as just enabling referential integrity between tables. There are also consequences of doing so or not doing so. There are three types of integrity:
Entity- The user must uniquely identify each record.
Referential Each foreign key value must have a matching primary key value......
View the rest of this paper...
Approximate Word Count: 856
Approximate Pages: 4 (250 words per double-spaced page)
Why should you join Frat Files?
- - It's safe, secure, and private.
- - Instant access to over 100,000 papers. New papers are added hourly.
- - Fast and reliable customer support.
Similar Essays
-
The Relavance Of Referential Integrity
The Relavance of Referential Integrity. The Relevance of Referential Integrity
Databases are the core of Information Systems. Without ...
Frat Files
Members
Information
© 2009 FratFiles.com.