Data Integrity In relational database management systems, data integrity ensures the accuracy, reliability and consistency of the data during any operation like as data manipulation, data retrieval, data storage, backup or restore operation etc. It also guarantees that the recording of data is accurate and as intended. Having any bad or unintended data in the database, is a failure of data integrity. For example, having sales detail in Sales table of a product not available in Product master is a failure of referential integrity. Below are few scenarios where we might require data integrity to accept and maintain valid, accurate and intended data in the database: We don’t have a NULL value as a product in Product master table. (Entity integrity) To ensure that we don’t have duplicate products in Product Master table. (Entity integrity) We don’t have any alphanumeric value in Amount column of Sales table. (Domain integrity) To ensure that Sales table doe...
Comments
Post a Comment