Re: Newbie question about db normalization theory: redundant keys OK?

From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Fri, 14 Dec 2007 18:28:42 -0000
Message-ID: <fjui36$c08$1$8302bc10_at_news.demon.co.uk>


Sorry Bob - celko.

-- 
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]


"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message 
news:4762c8ff$0$5301$9a566e8b_at_news.aliant.net...

> Tony Rogerson wrote:
>
>>> Why didn't you bother to print out a new schedule when you got back to
>>> campus?
>>
>>
>> Why? There should be no need; also - there would be considerable
>> contention as people came back to campus on the first day of the new
>> term.
>>
>>> spammed the campus with their classes for this term and any
>>> information from last term
>>
>>
>> I guess with the 2,000 students you would check there had been 2,000 read
>> receipts for the email you sent.
>>
>> You also assume that students have email off campus and don't just go
>> straight to class according to the schedule they got when signing up for
>> the class.
>>
>> You are so seriously divorced from any form of real world thinking - did
>> you get "shot in the buttock"?
>>
>>> 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.
>>
>>
>> What if that had been a hospital system and a patient and their
>> medication? You'd be given the wrong medication to the wrong patient
>> which could kill them.
>>
>> Folk like you are a real problem in the IT industry, your ignorance to
>> how the real world works and self importance rather than team importance
>> causes delays and failures across the spectrum of IT projects.
>
> Tony, it would be helpful if you did not remove the attribution at the top
> of your post. I have no idea who you responded to. Was it Joe? Or someone
> else?
Received on Fri Dec 14 2007 - 19:28:42 CET

Original text of this message