Guest
asked 3 years ago
1 Answer - Sort by: Date | Rating
Integrity
Database integrity means the correctness and consistency of data. It is another form of database protection. Security means that the data must be protected from unauthorized operations.
Integrity is related to the quality of data. Integrity is maintained with the help of integrity constraints. These constraints are the rules that are designed to keep data consistent and correct. They act like a check on the incoming data. It is very important that a database maintains the quality of the data stored in it.DBMS provides several mechanisms to enforce integrity of the data.
Types of Integrity
Two types of data integrity are as follows:
Entity Integrity
The entity integrity is a constraint on primary key value. It states that any attribute of a primary key cannot contain null value. If primary key contains null value, it is not possible to uniquely identify a record in a relation. Entity integrity ensures that it should be easy to identify each entity in the database.
Referential Integrity
The referential integrity is a constraint on foreign key value. It states that if a foreign key exists in a relation, the foreign key value match the primary key value of some tuple in its parent relation. Otherwise the foreign key value must be completely null.
Database integrity means the correctness and consistency of data. It is another form of database protection. Security means that the data must be protected from unauthorized operations.
Integrity is related to the quality of data. Integrity is maintained with the help of integrity constraints. These constraints are the rules that are designed to keep data consistent and correct. They act like a check on the incoming data. It is very important that a database maintains the quality of the data stored in it.DBMS provides several mechanisms to enforce integrity of the data.
Types of Integrity
Two types of data integrity are as follows:
Entity Integrity
The entity integrity is a constraint on primary key value. It states that any attribute of a primary key cannot contain null value. If primary key contains null value, it is not possible to uniquely identify a record in a relation. Entity integrity ensures that it should be easy to identify each entity in the database.
Referential Integrity
The referential integrity is a constraint on foreign key value. It states that if a foreign key exists in a relation, the foreign key value match the primary key value of some tuple in its parent relation. Otherwise the foreign key value must be completely null.
0
0
- How To Use Printer?
- How Does A Computer Storage A Data?
- Why Fixed Disk Error?
- What Are The Advantages Of A Wired Computer Network?
- How Computer Helps?
- How Computer Affects Study Habits?
- What Does A Blue Square With White "> >" On My MS Office File Icons On The Desktop Mean?
- Explain CPU And Its Parts ALU And CU?
- What Is Example Of People Ware?
- I Have A Desktop But Considering Buying A Laptop Will I Need A Router And Why?
- What Are Recent Applications Of Computer In Medical Field?
- What Is Image Distortion?
- How To Replace Ink In Epsom Dx4000?
- What Is Micro Echono Mics?
- How To Change The Ink Cartridge On A Sx200?
- What Is Voice Output?
- When Carry Flag Is Set?
- What Is First Computer Of The World?
- What Is A Main Frame Operating System?
- Refer To The Exhibit. A Technician Is Working On A Network Problem That Requires Verification Of The Router LAN Interface. What Address Should Be Pinged From This Host To Confirm That The Router Interface Is Operational?
- Can I Access Other Computers On My Personal Wifi Home System Without Other Computer Knowing?
- What Is Data Management Technology?
- What Is The Storage Group?
- Why It Is Not Working Properly?
- How To Scan From An Hp Deskjet F4400 And Where To Look On Computer?
New Comment - Comments are editable for 5 min.