1
I usually come across some questions that include the unique-key tag, and I consider that such an expression is redundant, since a KEY constraint (be it PRIMARY or ALTERNATE) is supposed to enforce uniqueness of the value (or values) contained in the column (or columns) involved.
Taking a look a...