Session1_Module1-2_Data Integrity_Indexes doc

Data Integrity & Indexes / Session 1/ 1 of 37

Session 1

Module 1: Introduction to Data Integrity

Module 2: Introduction to Indexes

Data Integrity & Indexes / Session 1/ 2 of 37

Introduction to data integrity

Objectives

Data Integrity & Indexes / Session 1/ 3 of 37

Data Integrity

 Need for updating data.

 Need for ensuring the validity and

consistency of data at all times: data

integrity.

 Integrity of data can be maintained by

specifying certain checks at the time of

creating and modifying tables and then

applying those checks when handling

data.