The image cncpt053.gif shows a UNIQUE key constraint defined on the DNAME column of the dept table to disallow rows with duplicate department names. If a null value is entered for the DNAME column, then the row is allowed. However, if a NOT NULL constraint is also defined on the DNAME column, then the row is not allowed.

End of image description.