SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Oct 2002
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database schema tutorials and examples?

    Hi guys

    Does anyone know of any good sites that give real world examples, explanations of database schema,s and how you represent each relationship etc. Preferably with mySQL as the database of choice and the different types of fields (boolean, etc)

    I,m trying to design a database and am finding it hard going.

    Thx guys, hope someone can point me in the right direction.
    Recoil UK

  2. #2
    SitePoint Guru nagrom's Avatar
    Join Date
    Jul 2001
    Location
    Western CT, USA
    Posts
    803
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    this webmonkey article may be helpful:
    http://hotwired.lycos.com/webmonkey/99/13/index0a.html

  3. #3
    SitePoint Member
    Join Date
    Oct 2002
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi again.

    Thx for the reply. I have another question though.

    I,ve read many tutorials on database design, and they seem very good, but mySQL has a boolean field type and i,m unsure what its purpose is.

    I know it returns a value of 0 for false and 1 for true, and can be used to represent options, but can you also use it to determine if a relationship exists in another table, thereby eleminating the need to search for it everytime.

    This way you could base your sql queries on the data contained in the boolean fields, i,m thinking that this has to faster than joining uneccessary tables.

    I,m probably wrong though, and there exists a very good reason why this shouldnt be done.

    Look forward to everyones replies

    Thx again
    Recoil UK

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,350
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    hey recoil, i like the way you think

    what you should do, and it's really quite easy, is build a couple of tables and try this join concept yourself

    i'd be interested in seeing the sql you come up with


    rudy
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

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