|
-
Supertypes and subtypes are logical design concepts, you need to transform them into tables to implement.
You have two choices.
1. Create the super type entity as a table with a subtype column and create a table for each sub type, in each sub type table add a foreign key pointing to super type table.
Disadvantage of this is, you need to join two tables to get complete information.
2. You can collapse the super type and subtypes into one table. You may end up with many nulls in columns that are not relevant to the current record.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|