SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Wizard aaron.martone's Avatar
    Join Date
    Feb 2003
    Location
    Florida, USA
    Posts
    2,322
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Quick how-to on Relational DBs?

    Ok, I need a quick run-down on relational data in a SQL 7 database.

    First of all, I think it'd be best if I state whether or not I understand what relational data is before I get into this.

    Many applications are very modular, and data relies on other data, which sometimes can be crosslinked and referenced by many other areas of the database.

    Relational comes from the term that many different aspects of your database (fields and what not) can relate to other fields in differnt manners.

    I've heard of ONE TO ONE, ONE TO MANY and MANY TO MANY, but I don't know what this means.

    If this is what relational DB's are all about, does anyone have a good article so I can get the jest of proper database setup? (SQL7 if possible)

    Things that worry me are like, how you add records to a DB, and the index will goto 1, then 2, and keep on auto incrementing. Well, say a user deletes record 5. This record could have fields that "relate" (link?) to other tables and fields and should either delete those records as well or affect them in other ways.

    This is what I need to learn; proper setup of a DB so that when modifications are made to it, the DB still remains functional. Anyone got good reads?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,275
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)

  3. #3
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ...and also
    http://www.sitepointforums.com/showt...threadid=63582



    And this site is full of interesting reading:
    http://r937.com
    Last edited by jofa; Feb 24, 2003 at 07:21.

  4. #4
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by jofa
    ...and also
    http://www.sitepointforums.com/show...?threadid=63582



    And this site is full of interesting reading:
    http://r937.com
    The ... got in there jofa [edit] ok that's fixed

    And ditto on http://r937.com

  5. #5
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by redemption
    The ... got in there jofa [edit] ok that's fixed
    I'm too stupid for this new textarea thing

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,275
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    thanks for the kind words about my site, guys

    i truly appreciate it

    now, if it would only land me some more work...

  7. #7
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by r937
    ...now, if it would only land me some more work...
    Finding work is never a problem, only problem I had recently is getting paid for the work


    More info to aaron:
    There's a section called Join Fundamentals in
    SQL Server 7.0 Online Documentation



    Edit: I need to read "WYSIWYG editor fundamentals"...
    All links I include are completely messed up

  8. #8
    Made with a Mac! philm's Avatar
    Join Date
    Sep 2001
    Location
    Portsmouth, UK
    Posts
    735
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by jofa
    Edit: I need to read "WYSIWYG editor fundamentals"...
    All links I include are completely messed up
    {giggles}

  9. #9
    SitePoint Wizard aaron.martone's Avatar
    Join Date
    Feb 2003
    Location
    Florida, USA
    Posts
    2,322
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Great reads you guys! I'm reading over every tutorial in each page you guys posted.

    Data Modeling. So that's the term for developing Databases to work in a functional and relational manner. Cool!

    You guys kick [radio edit]. Thx!


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
  •