In Database Systems What Is Meant By Referential Integrity?
What do you know about it?
1 Answer - Sort by: Date | Rating
Referential integrity is a rule that also helps in maintaining the organized form of data. It preserves the relationships defined between the data entities during the data updates. In the case of relational data model, relations/tables are the data entities. All these entities in a database are connected with on another via one or more attributes. These attributes are normally called 'primary key 'of the table.
By applying the rules of referential integrity, you ensures that no any update can be effective that destroy the relations defined between tables , i.e. no any value of foreign key can be entered that does not has a corresponding primary key value in the related table.
In a database, data is stored in more than one relation, thus complete information about an entity may be stored in more than one tables. When two relations/tables are linked with each other through a relationship, one is called a master table and other is called child table.
The referential integrity rules are used in such cases to provide the following advantages:
1. If the record does not exist in master table, it can not be stored in child table.
2. A record can not be deleted from master table unless that record is deleted first from relevant child table.
By applying the rules of referential integrity, you ensures that no any update can be effective that destroy the relations defined between tables , i.e. no any value of foreign key can be entered that does not has a corresponding primary key value in the related table.
In a database, data is stored in more than one relation, thus complete information about an entity may be stored in more than one tables. When two relations/tables are linked with each other through a relationship, one is called a master table and other is called child table.
The referential integrity rules are used in such cases to provide the following advantages:
1. If the record does not exist in master table, it can not be stored in child table.
2. A record can not be deleted from master table unless that record is deleted first from relevant child table.
0
0
- Discuss The Challenges Of Data Base Management Today?
- Describe The Problems With Two-tier Client-server Dbms Architecture?
- What Is The Difference Between Two Tier And Three Tier Client/server Architecture?
- Describe The Problem With Two- Tier Server Dbms Architecture?
- What Is The Difference Between Two-tier And Three Tier Client Server Architecture?
- How Can I Create A Online Banking Database?
- 1.7. What Is A Database System?
- How Can I Describe A Erd?
- What Is The Difference Between Procedural And Non Procedural DML?
- What Is A Good Database Design?
- What Are The Advantages Of Normalisation?
- What The Functions Of My Sql?
- What Is The Glycaemic Index?
- Describe The Function That Should Be Provided By Modern Full Scalemulti User Dbms?
- Discuss The Responsibilities Of Database Administrators?
- What Are The Approaches For Managing The Design Of A Database System That Has Multiple User View?
- What Is The Main Advantage Of Telex System Over The Telephone?
- How Do You Plan Database?
- What Is How Many Types User In Dbms?
- What Is The Difference Between Drop,delete, Truncate In Database?
- Discus Various Objective Data Base Approach Which Objectives Do You Consider Most Important And Why?
- Who Many Dbms And Name Dbms?
- How Properties Are Conserved When Database Is Distributed?
- Why Is The Relational Database Approach Better Than Earlier Methods?
- Can Anyone Give Me An Example Of A Paper Based Database?
- Is There Any Situation Where Database Is Possible Without Entity And Referential Integrity?
- How Will You Insert And Delete With A Single Java Connection When You Have Referential Integrity?
- What Is History Of Database Systems?
- What Do You Know About Relational Database Systems?
- What Is Distributed Database Systems?
- What Are The Different Normalforms Used In Database Management Systems?

New Comment - Comments are editable for 5 min.