This is just the stuff I've run into with a few hours work.
Supertypes/subtypes. Creating a relation so a subtype does
not work in a suitable manner. I ran into this last week, and don't
recall the details. The solution was not to use super/sub types,
though I would have preferred it.
Creating a FK relationship to table A from table B and C, where
B and C have the same primary key. I use PK for the primary
key on entities/tables, and assign the UID as an alternate key.
When trying to do this, ER doesn't do it properly. It uses the same
attribute/column for the FK to both B and C.
Creating >1 relations between 2 tables using the same primary
key from the parent. This is very common. ER doesn't like this.
I struggled with it a bit last week, don't yet have it resolved.
All of the above are quite easy in Oracle Designer.
I'll probably find more...
Jared
"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/15/2002 11:26 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: designer autolayout
Ok, I'll bite. Can you name a few Designer features that ER Studio is
missing?
I have not used either product, I am stuck with an ancient version of
ERwin. Mgmt almost purchased ER Studio, but then the economy, and
business, crashed...
-----Original Message-----
Sent: Tuesday, October 15, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L
No.
Though I'm not currently using Designer, I've worked with it quite a bit
in the past for data modeling. Don't use the autolayout.
I'm currently using Embarcadero ER Studio. If Designer wasn't such a pig,
I would have bought it instead, and am currently wishing I had anyway.
ER Studio is very fast, but not *nearly* the tool that Designer is.
Jared
"Boivin, Patrice J" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/15/2002 06:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: designer autolayout
Is there a way to make the autolayout feature produce a concise layout in
Designer Entity Relationship Diagrammer?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst�mes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | R�gion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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.com
--
Author: Grabowy, Chris
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
