Re: Creating a relationship between 2 tables

From: tony_becky_mikey_verizon_news <tony_becky_mikey_at_verizon.net>
Date: Wed, 26 Jul 2006 04:32:03 GMT
Message-ID: <7fCxg.8387$V74.2173@trnddc08>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1153845184.892847_at_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

Now you understand why I had my resume passed to you at the last Oracle days in Bellevue. The IT situation here is bleak, and as long as want to continue working with Oracle, I have to belong to the City's IT union and such... Received on Tue Jul 25 2006 - 23:32:03 CDT