Why are entity and referential integrity important in a database?
Answers
to store a large amount of in information in recognized and easy accessible way in any of the department.
Answer:
Entity integrity - : Entity integrity is a property that ensures that the the attribute that is going to be primary key should not be duplicated and should not be null.It is one of the property for consistency of database. Primary key of a database is unique for every touple.Primary keys help identifies every touple in database . The INSERT and UPDATE operations are blocked to prevent any any duplication in data . Entity integrity provides mechanism for maintaing database.
Referential integrity -: Referential integrity is a property that ensures the relationship between primary key of parent table and foreign key of child table . The attributes containing primary key and foreign key should not be deleted because to it is used as a connection between two tables.
Explanation: