Databases – Built-in Integrity Constraints

• Integrity constraint – rule that helps ensure the quality of information

• Examples

  • Primary keys must be unique
  • Foreign keys cannot be blank
  • Sales price cannot be negative
  • Phone numbers must have an area code

McGraw-Hill

© 2007 The McGraw-Hill Companies, Inc. All rights reserved.

Previous slide

Next slide

Back to first slide

View graphic version