Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    8

    Data model - ideas?

    Hey all. I'm faced with the task of creating a data model for a new blog hosting website. Any ideas as to what I need to include in my design? As entities and attributes go, this is what I've thought of so far.

    Users (those who have acquired blog space from the site)
    - User ID#
    - First name
    - Surname
    - Country
    - State/County/Region
    - E-mail address

    Blog Information (details of various blogs under the site)
    - Blog ID#
    - Blog name
    - Date acquired
    - Description
    - User ID

    Transactions (various monetary transactions)
    - Transaction ID#
    - Date
    - Transaction Type
    - Amount

    Traffic (hits per site per week)
    - Week ID#
    - Blog ID#
    - Number of hits
    - Number of posts
    - Average time spent on site

    And that's about all I've got right now. I'm sure there's plenty more I could include so any suggestions would be awesome. Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    I'd suggest another table to host country details, and if you wish a sub table to that to idntify region or state or couty (ie country subdivision). if you were stciking within the US its no problem, but personally I always find it parochail when international sites have a text box for state (and helpfully list US states & 'other', some even recognise (sorry recognize) Canada.

    The average should not be stored as its derived data. you may have a very good reason to store it but generally you would store sstart and funishtime.

    capturing finish time in we bistes can be problematiical, not all users dutifully clock in and out when the visit the site, and when registered they don't always clock out.

    equally you may have some lurkers who fire up their computer and leave the page / site running in background and open up the page periodically

    I see no details of what the little dears have actually writen in their logs

    come to think about it most of the traffic log could come form the site log

    enjoy your homework
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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