This illustration shows Table DEPT, which has three columns:

• DEPTNO
• DNAME
• LOC

The DEPTNO column has a Primary Key--no row may duplicate a value in the key and no null values are allowed.

This illustration shows that two rows cannot be inserted into Table DEPT because one duplicates an existing value in the primary key, while the other contains a null value for the primary key.