Re: Creating a relationship between 2 tables

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 25 Jul 2006 21:32:37 -0700
Message-ID: <1153845184.892847@bubbleator.drizzle.com>

tony_becky_mikey_verizon_news wrote:

> "DA Morgan" <damorgan_at_psoug.org> wrote in message 
> news:1153692949.404846_at_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
> 
> Some of are different, but are getting lynched by our co-workers for wanting 
> to change the way they have done stuff for 20 years..

No doubt you have a target painted on your back.

I have a former student who was hired at a very large aerospace firm who was reprimanded for working too hard and making the rest of the team look bad. Government is often worse.

-- 
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 Tue Jul 25 2006 - 23:32:37 CDT