Re: Creating a relationship between 2 tables

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 24 Jul 2006 06:16:33 -0700
Message-ID: <1153692949.404846@bubbleator.drizzle.com>

tony_becky_mikey_verizon_news wrote:

> "DA Morgan" <damorgan_at_psoug.org> wrote in message 
> news:1153588495.761082_at_bubbleator.drizzle.com...

>> Andyza wrote:

>>>> You design is horrible.
>>> I know! That's how I inherited it! But gotta work with what we've got
>>> for now...
>>>
>>>> Why is SYSTEMID the PK for students and not STUDENTID?
>>> Because STUDENTID isn't guaranteed remain constant. And in some cases
>>> the STUDENTID might change over time. And some users might have more
>>> than one STUDENTID. It's used only for display purposes because users
>>> get a warm fuzzy feeling when they see it on reports...
>>>
>>>> You have gone pseudokey happy.
>>> Yeah! Is that a new drug?
>>>
>>>> This looks like a homework assignment,
>>> ROFLOreallyreallyL! Thank you. That made my day!
>>>
>>>> Look up the UPDATE statement.
>>>> (BIG HINT you will use a version that includes a subquery).
>>> That's what I've done since I posted the original message - a
>>> "sub-subquery" in a subquery in an update statement. It's awful...
>>> I'll post some code and "re-explain" myself.

>> I get the impression from your response to Ed that this is real work
>> and not schoolwork: Amazing!

>>

>> If so polish up your resume and find a place to work where there is
>> a whiff of competence. Learning bad practices is not a good career
>> path.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

> 
> Except if you want to work in Gov't.. This mentality (limited quality, more 
> work) is what keeps developers there many years after they should have moved 
> on.. Take it from someone who is witnessing it in real time!!

Agreed. Then on the other hand the government employees all shrug their shoulders and wonder why the tax payers want to lynch them.

Well duh!

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Jul 24 2006 - 08:16:33 CDT