RE: J2EE Question

Hi:

If this join table would not going to have it's own child table(s), then two FKs are good enough. But I often find that if we ever need to add another child table to this join table,then a PK in this join table would make things much easier to handle. It is just one more PK and one sequence to add (take some disk space though), but it shouldn't be any problem. I do it all the time.

Guang

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of DENNIS
> WILLIAMS
> Sent: Thursday, April 24, 2003 10:07 AM
> To: Multiple recipients of list ORACLE-L
> Subject: J2EE Question
>
>
> We are in the process of creating some significant new
> schemas. Everything
> is being normalized, by the book. Now the Java developers are
> saying that on
> the associative entities, where many-to-many relationships
> are resolved by
> an extra table, they want an artificial key to be added.
> Normally these
> tables have two keys, one from each parent table. But the
> developers want an
> additional sequential key added to help them track this
> entity. They say it
> makes it easier to keep track of this object in the EJBs. Has anyone
> encountered this situation? Not being familiar with J2EE, I
> haven't a clue
> whether this is a reasonable request.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: gmei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).