Page 79 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database Pawan Kumar, Lovely Professional University

Notes Unit 5: Integrity Constraints

CONTENTS
Objectives

Introduction
5.1 Integrity Constraints

5.2 Authorization
5.3 DCL Commands
5.4 Embedded SQL

5.5 Dynamic SQL
5.6 Summary

5.7 Keywords
5.8 Self Assessment
5.9 Review Questions

5.10 Further Readings

Objectives

After studying this unit, you will be able to:
 Describe integrity constraints

 Know authorization
 Explain DCL commands
 Describe embedded and dynamic SQL

Introduction

Sometimes a class type really represents a collection of individual components. Although this
pattern can be modeled by an ordinary association, its meaning becomes much clearer if we use
the notation for an aggregation. Database objects map capability between Java objects and a
relational database (RDBMS) in a standard an highly extensible way, so that the objects themselves
can be used in your application, removing the need to embed SQL code directly into your Java
applications.

5.1 Integrity Constraints

Integrity constraints ensure that changes made to the database by authorized users do not result
in a loss of data consistency. Thus, integrity constraints guard against accidental damage to the
database.

72 LOVELY PROFESSIONAL UNIVERSITY