Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Modeler: Naming

brianrayDec 15 2009 — edited Dec 18 2009
OK guys, I'm struggling.

I've watched the on-line tutorials, read the white papers (especially "Naming Standardization"), and looked through the help pages. There are so many options for controlling naming that I think I'm lost in the trees trying to find the forest. Between the name, short name, synonym, synonym to display, preferred abbreviation, naming rules, glossaries, naming standards, templates, object name prefixes, name abbreviations, name translations, design rules, and classification types, I'm a bit overwhelmed.

I'd like to take this logical model:
---------------------
| facility category |
---------------------
facility category identifier <PK>
     1:1
      |
      |
      |
     0:M
------------
| facility |
------------
facility identifier <PK>
facility category id <FK>
and create the following relational model:
-------------
| t_fac_cat |
-------------
fac_cat_id <PK>
  1:1
   |
   |
   |
  0:M
---------
| t_fac |
---------
fac_id <PK>
fac_cat_id <NN,FK>
which, in turn, generates this DDL:
create table t_fac ( 
     fac_id integer  not null , 
     fac_cat_id integer  not null ) ;

alter table t_fac add constraint pk_fac primary key ( fac_id ) ;

create table t_fac_cat ( fac_cat_id integer  not null ) ;

alter table t_fac_cat add constraint pk_fac_cat primary key ( fac_cat_id ) ;

alter table t_fac 
    add constraint fk_fac_cat_2_fac foreign key ( fac_cat_id ) 
    references t_fac_cat ( fac_cat_id ) ;
Note: I could live with the relational model table names not being prefixed with a 't_' as long as the DDL includes it.

I think the tool has the ability to do what I want, but I'm missing how all the parts fit together to enable me to accomplish my goal.

Does anyone have a simple approach that might decrease the learning curve a bit?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2010
Added on Dec 15 2009
5 comments
8,621 views