Submit Your Article Forum Rules

Results 1 to 5 of 5

Thread: Can anyone help me draw up a data model?

  1. #1
    Junior Member
    Join Date
    Feb 2010
    Posts
    2

    Can anyone help me draw up a data model?

    Ok for my coursework i have to draw a data model for any scenario of my choice, we are allowed to take an existing data model from the internet, problem is, the teacher has been VERY specific about the relationships that have to be included in the model, and im finding it extremelly difficult to find something that possesses all these elements.

    Could someone help me? Suggest a scenario to use and give examples of how each of these points would be covered? Or draw me up an example?

    • 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

    Thank you!

  2. #2
    WebProWorld MVP kgun's Avatar
    Join Date
    May 2005
    Location
    Norway
    Posts
    7,711

    Re: Can anyone help me draw up a data model?

    Buy this Simply SQL - SitePoint Books book (available in PDF format for instant download).
    Hidden Content :: Hidden Content
    Hidden Content
    Conversations creates communities and conversions create profit.

  3. #3
    Junior Member
    Join Date
    Feb 2010
    Posts
    2

    Re: Can anyone help me draw up a data model?

    Quote Originally Posted by kgun View Post
    Buy this Simply SQL - SitePoint Books book (available in PDF format for instant download).
    Are you trying to sell me something?

    I know SQL. i just don't know any scenarios that are structured in such a way as shown by the bullet points

  4. #4
    WebProWorld MVP kgun's Avatar
    Join Date
    May 2005
    Location
    Norway
    Posts
    7,711

    Re: Can anyone help me draw up a data model?

    That is fully explained in that book. I have no more time to help you. Generally:

    Look at AgileData.org

    More precisely: AgileDataModeling
    Hidden Content :: Hidden Content
    Hidden Content
    Conversations creates communities and conversions create profit.

  5. #5
    Junior Member
    Join Date
    Apr 2010
    Posts
    1

    Re: Can anyone help me draw up a data model?

    Quote Originally Posted by Jskirt View Post
    Ok for my coursework i have to draw a data model for any scenario of my choice, we are allowed to take an existing data model from the internet, problem is, the teacher has been VERY specific about the relationships that have to be included in the model, and im finding it extremelly difficult to find something that possesses all these elements.

    Could someone help me? Suggest a scenario to use and give examples of how each of these points would be covered? Or draw me up an example?

    • 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

    Thank you!
    Hey buddy, you can draw up a model for an invoice with affiliates where the affiliates have parent affiliates. Products to invoices will give you your many to many relationship.

Similar Threads

  1. Using tables to draw boxes
    By houdini987 in forum Graphics & Design Discussion Forum
    Replies: 1
    Last Post: 11-14-2006, 10:18 PM
  2. Google Maps & Maps API Draw From Different Data
    By WPW_Feedbot in forum Search Engine Optimization Forum
    Replies: 0
    Last Post: 10-12-2005, 09:30 AM
  3. Sploggers Quick on the Draw
    By jmiller in forum eCommerce Discussion Forum
    Replies: 0
    Last Post: 08-22-2005, 09:31 AM
  4. Corel Draw Issues
    By grease in forum Graphics & Design Discussion Forum
    Replies: 4
    Last Post: 10-23-2003, 04:57 PM

Posting Permissions

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