What type of shop does the widow have ?
Holding each shop 's Shop Type only once would seem preferable , as doing so would prevent such anomalies from occurring:In this revised design , the " Shop Near Person " table has a candidate key of { Person , Shop } , and the " Shop " table has a candidate key of { Shop } .