Skip to Main Content

SQL Developer

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!

How to create super and sub type entities (tables) in Data Modeler

710217Sep 10 2009 — edited Sep 14 2009
Dear All,

I have this database design where i have.

1 - A customers entity/table with cust_id & cust_type_id columns.
2 - A customer_types entity/table with cust_type_id & cust_type_name columns.
3 - A individual_customers entity/table with cust_id, cust_firstname. cust_lastname and annual_income columns.
4 - A company_customers entity/table with cust_id, company_name & CEO columns.

a - I have simplified the tables and excluded many columns.
b - The customers entity/table is a super type with respect to the individual_customers entity/table and company_customers entity/table with one to one relationship between them.
c - The type discriminator is the cust_type_id column.
d - The customer_types entity/table records types of customer (individual person, sole proprietorship,partnership, corporation, and so on)
e - The logical model is to be implemented in to a physical with a three-tables approach (as is).

Now In IDEF1X notation, the type is shown using a symbol that looks like a circlewith a line under it. Further more the relationaship is either disjoint or overlaping. How do I implement this design in Orcale SQL developer Data Modeler. I want to create a super type entity/table called customers and have two sub type entity/tables called individual_customers & company_customers. Some thing like this

http://i31.tinypic.com/14ipdol.jpg

I do not see any options in Oracle SQL Developer Data Modeler for super types & subtypes. Does this mean that it does not support inheritance (specialization & generalization) OR that I should just create all the required entities/tables and join them with one to one relationships with out stating that they are super & sub types.
This post has been answered by 494437 on Sep 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2009
Added on Sep 10 2009
17 comments
14,417 views