Specifying Key Constraints

The keyword UNIQUE is used to specify a key. The system then automatically guarantees that key integrity holds holds.

 
I3: 		 CREATE  		 UNIQUE 		 INDEX 		 SSN_INDEX

		 		 		 ON 		 EMPLOYEE(SSN);