Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating a relationship between 2 tables

Re: Creating a relationship between 2 tables

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 22 Jul 2006 10:14:54 -0700
Message-ID: <1153588495.761082@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
Received on Sat Jul 22 2006 - 12:14:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US