Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2010
    Posts
    5

    Unanswered: Can anyone find me a data model i can use for my coursework?

    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

  2. #2
    Join Date
    Jan 2010
    Posts
    5

    Can anyone find me a data model i can use for my coursework?

    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

  3. #3
    Join Date
    Jan 2010
    Posts
    5

    Can anyone find me a data model i can use for my coursework?

    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

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002

  7. #7
    Join Date
    Jan 2010
    Posts
    5
    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!

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •