Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    11

    Database design pitfalls

    Hi,

    I am very new to the database design. I am designing my first database to a web application using Microsoft SQL server 2000.

    I started creating tables following the baisc principles of Normalization. Apart, I am not sure what is required ? Can any one point me to a good book or a website which describes the common erros occur during a database design.

    Also, Plz advice me on the process I should follow for designing an effective database system.

    Thanks
    -Sudhakar

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by sudhakar_112
    Hi,

    I am very new to the database design. I am designing my first database to a web application using Microsoft SQL server 2000.

    I started creating tables following the baisc principles of Normalization. Apart, I am not sure what is required ? Can any one point me to a good book or a website which describes the common erros occur during a database design.

    Also, Plz advice me on the process I should follow for designing an effective database system.

    Thanks
    -Sudhakar
    You can try this book,its good for the beginners...
    Wrox-Professional SQL SERVER 2000 Database Design

    Joydeep

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Here's an introductory tutorial that I wrote for an INet sister-site. The first two installments deal with table design and normalization.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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