Recent content by vegetables2001

I thought normalisation was there to: 1. Allow easier updating of record. 2. Reduce database size. I had pretty much come to the same conclusion myself as you guys above but I was worried I might have missed something obvious. Thanks for the advice guys.

OK, I'll try to put it context. Building a database to record when lorries visit a particular shop. ie. unit shop date DK55 BHP Leeds 3/9/2009 YR59 YSS Sheffield 6/6/2010 YR59 YSU Wath 25/11/2009 This is just a little bit of the whole database, but should...

Sorry, newbie here, I apologise if this in the wrong forum, however, here goes: In normalisation no piece of data should be duplicated within a database - however is it really a worthwhile practice to place a just a date ( plus key of course) in a table on its own?