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).