223k views
0 votes
Why would "ExpirationDate” be a poor choice as a primary key?

Date/Time data type cannot function as a primary key.
Primary key choices should contain a decimal data type.
There could be more than one item with the same expiration date.
Date/Time is always used as a Boolean data type.

1 Answer

4 votes
There could be more than one item with the same expiration date, and primary keys must be unique.
User Neftanic
by
7.9k points