Table-Level Integrity

This type of integrity ensures the following:

  • There are no duplicate records in a table.

  • The primary key exclusively identifies each record in a table.

  • Every primary key value is unique.

  • Primary key values are not null.

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.