Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating a relationship between 2 tables
Andyza wrote:
>> You design is horrible.
>> Why is SYSTEMID the PK for students and not STUDENTID?
>> You have gone pseudokey happy.
>> This looks like a homework assignment,
>> Look up the UPDATE statement. >> (BIG HINT you will use a version that includes a subquery).
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.orgReceived on Sat Jul 22 2006 - 12:14:54 CDT