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

    What is a good scenario for a data model?

    for my coursework i have been asked to draw up a database model.
    specifically, it says we cannot use any of the models we have been using during classwork, these models were a school, customer/order, and a hospital.

    The model must contain:

    • At least one one-many relationship

    • At least one decomposed many-many relationship-show the original many-many relationship (i don't know what this means, anyone shed some light?)

    • At least one recursive relationship (Don't know what this means either)

    • 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. (or this)

    Could anyone suggest to me what would be a good scenario to use? And perhaps suggest some relationships this could have?

    BTW: I'm not too good at my database module at uni, so somethign really complex might be a bit difficult for me to use, i need something which includes all those but isnt TOO complex.

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You should model something you know so you lose the abstract nature of it. Your CD, book or DVD collections. Recipes. One of your interests. With these you have real, physical world things you can refer to.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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