Maintaining Data Integrity

Data Integrity Data integrity means that data in a database adheres to business rules. There are three primary ways in which data integrity can be maintained: Application code Database triggers Declarative integrity constraints Mapping the business rules using one of the three methods is a design decision. The database administrator is primarily concerned with implementing the methods chosen by the designer and balancing the performance needs against integrity requirements. Application code can be implemented either as stored procedures within the database or as applications running on the client. This lesson focuses on the use of integrity constraints....