We are allowed to take an existing data model from the internet

it needs to have all these:

• At least one one-many relationship
• At least one decomposed many-many relationship-show the original many-many relationship
• At least one recursive relationship
• At least one one-one relationship
• An entity with subtyping that has relationships with other entities that involve the super-type and at least one subtype.
• No less than 8 entities, no more than 10

i'm finding it hard to find a data model with a recursive relationship or "An entity with subtyping that has relationships with other entities that involve the super-type and at least one subtype." (i'm not quite sure what that means?)

could anyone suggest to me what data model i could use or link me to one that has all of these aspects?

Thanks

We are allowed to take an existing data model from the internet

it needs to have all these:

• At least one one-many relationship
• At least one decomposed many-many relationship-show the original many-many relationship
• At least one recursive relationship
• At least one one-one relationship
• An entity with subtyping that has relationships with other entities that involve the super-type and at least one subtype.
• No less than 8 entities, no more than 10

i'm finding it hard to find a data model with a recursive relationship or "An entity with subtyping that has relationships with other entities that involve the super-type and at least one subtype." (i'm not quite sure what that means?)

could anyone suggest to me what data model i could use or link me to one that has all of these aspects?

Thanks

We are allowed to take an existing data model from the internet

it needs to have all these:

• At least one one-many relationship
• At least one decomposed many-many relationship-show the original many-many relationship
• At least one recursive relationship
• At least one one-one relationship
• An entity with subtyping that has relationships with other entities that involve the super-type and at least one subtype.
• No less than 8 entities, no more than 10

i'm finding it hard to find a data model with a recursive relationship or "An entity with subtyping that has relationships with other entities that involve the super-type and at least one subtype." (i'm not quite sure what that means?)

could anyone suggest to me what data model i could use or link me to one that has all of these aspects?

Thanks

try Library of Free Data Models from DatabaseAnswers.org

try Library of Free Data Models from DatabaseAnswers.org

try Library of Free Data Models from DatabaseAnswers.org

haha!! i see what you did there sorry about the tripple post... i was posting from uni and the internet is pretty bad, it must have lagged.

thanks, i'll have a look!

actually it's almost a certainty that the lag was on the dbforums server

good luck with picking a data model

be aware that other students looking for data models will also find that site