CIS4365: Database Applications
Fall, 2017

UTEP Oracle 9i
UTEP Oracle 10g Notes


[Home |Links]

Table-Level Integrity

This type of integrity is a major component of overall data integrity, and it 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.

You began establishing table-level integrity when you defined a primary key for each table and ensured its enforcement by making absolutely certain that each primary key fully complied with the Elements of a Primary Key. In the next chapter, you'll enhance the table's integrity further as you establish field specifications for each field within the table.


Previous Section                                                                                                                                4. Reviewing the Initial Table Structures | Next Section




Submitted by Kumar Shivaswamy