* unique constraint uniquely identifies each record in a database table
*unique and primarykey gives a guarantee for uniqueness for cloumn or set of columns.
*primarykey automatically has a unique constraint on it
*we can have many unique per table
*we can have only one primarykey per table.