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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.