Table of ContentsCMSC-461 Outerjoin Dangling Tuples Outerjoin in SQL2 Outerjoin in SQL2 (II) Oracle Outerjoin Example Problem Constraints Outline Foreign Keys Example Alternative What Happens When a Foreign Key Constraint is Violated? Example What Happens When a Foreign Key Constraint is Violated? (II) Selecting a Policy Selecting a Policy (II) Selecting a Policy (III) Attribute-Based Checks Attribute-Based Checks Example Attribute-Based Checks (III) Tuple-Based Checks Example Triggers Triggers (II) Example Example (II) Options Notes Notes (II) Example Example (II) |
Author: Gary L. Burt
Email: burt@umbc Home Page: www.cs.umbc.edu/~burt |