Re: Newbie question about db normalization theory: redundant keys OK?
Date: Fri, 14 Dec 2007 09:13:14 -0800 (PST)
>> On my printed off time table it states 'Ms Fred', now, half way through the school year while on a term break the teacher gets married and is now called 'Mrs Sid' - how does my timetable now link back to the original entity - it can't, now, I return back from my holiday and wander around campus looking for a teacher called 'Ms Fred' but to no avail. <<
I gather that a "time table" is what we would call a "class schedule" over here.
Why didn't you bother to print out a new schedule when you got back to campus? As the DBA, I would have done a simple update in the Schedule table over the holidays, sent the lady some flowers and spammed the campus with their classes for this term and any information from last term ("Tony, you flunked RDBMS 101 and have to take it over").
As the DBA, it is my job to keep the database consistent; I am not responsible for lazy, confused students who cannot find their own classes in my consistent, normalized Database. You want to see Student Health Services or read your email with the current data in it. Received on Fri Dec 14 2007 - 18:13:14 CET