Re: Creating a relationship between 2 tables

"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!! Received on Sat Jul 22 2006 - 20:17:12 CDT