Of the several ways to enforce business rules in the database, only constraints can guarantee that the business rules are always enforced for all the data. This paper teaches how to apply foreign key constraints with the ON UPDATE CASCADE clause to implement waterproof solutions for several common real world problems.
Did you find this white paper useful?
18 out of 41 users found this white paper useful
Related white papers
PEM Division of BHEL Improves Team Collaboration and Customer Satisfaction
Bharat Heavy Electricals Limited (BHEL), one of the largest manufacturing and engineering companies in India, has over 180 products in the energy and energy infrastructure sectors. The Project Engineering Management...
SQL Server 2005 Administration
Learn to administer and tune SQL Databases and Servers. Description: Get the knowledge and skills you need to maintain a Microsoft SQL Server 2005 database in this 5-day course. Learn how to...
Microsoft Exchange Server 2007
Learn about Exchange 2007 and how to leverage its features. Description: Exchange Server 2007 is the latest version of Microsoft's premier messaging application. In this hands-on course, you'll learn to install and...
Powerful Data Warehousing Performance With IBM Red Brick Warehouse
A data warehouse typically provides business intelligence value through an Relational DataBase Management System (RDBMS) optimized for OnLine Analytical Processing (OLAP), which deals with extracting and viewing data from different...
Metrics Guide for Knowledge Management Initiatives
The Department of Navy (DON) Chief Information Officer (CIO) has led the development of an Information Management/Information Technology (IM/IT) Strategic Plan to build a knowledge sharing culture and exploit new...
Oracle Streams - Replication Tips and Techniques
Oracle Streams is a uniquely flexible feature for information sharing within Database 10g. The three basic elements of Oracle Streams, capture, staging, and consumption, can be configured in a number...
The Complete Guide to Developing B2B RFI
Here's an invaluable resource from Sterling Commerce that's designed to help business and IT executives ensure a B2B solution to meet their needs. The paper presents a variety of application-specific...
