RE: No primary keys

I'd like to see when (time of day, day of week, season of year) you're buying your latte. Should my counter staff gear up for espresso in the morning, and latte in the afternoon? Remember that ubiquitous beer and nappies (diapers) story -----Original Message----- From: Mark Townsend [mailto:markbtownsend@home.com] Sent: 12 January 2001 04:22 To: informix-list@iiug.org Subject: Re: No primary keys Maybe, but not necessarily if you are running a loyalty programme based on nbr of visits > From: "Andrew Hamm" <ahamm@sanderson.net.au> > Organization: CWO Customer - reports relating to abuse should be sent to > abuse@cwo.net.au > Newsgroups: comp.databases.informix > Date: Fri, 12 Jan 2001 15:03:31 +1100 > Subject: Re: No primary keys > > Mark Townsend wrote in message ... >> And you definately don't need to be able to uniquely identify rows. Buy two >> lattes from Starbucks on the same day on the same credit card for the same >> price, and in a DW you would never need to find just one or the other of >> these rows. >> > But surely the total sales would be collated into one row? Why store two in > a DW or a DM? > > >