I have a table in this format:
Name: Varchar
Food: Varchar
Date: Date
There's no primary key.
e.g. Sam eats icecream on 19 Sep 2007, then the record will store
Sam, icecream, 19 Sep 2007.
If the case:
Sam, icecream, 19 Sep 2007.
Susan, icecream, 20 Sep 2007.
Jacky, icecream, 21 Sep 2007...