Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2002
    Location
    Toronto
    Posts
    13

    Database Design Literature

    Hello.

    I am about to start designing a postgreSQL database, my first db. Can anyone reccomend any useful literature that pertains to database design (not necessarily specific to postgre)? Im just looking to avoid common design mistakes and soak up some design principles.

    Thanks.

  2. #2
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74
    I'd suggest taking a look at any DBMS Theory book and particularly read the chapters on "Normalization", because thats one important thing you will thing that will definitely help you to design a non-redundant and efficient database.

    A good book for DBMS Theory is "Database Management Systems" by Ramakrishnan & Gehrke.

  3. #3
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74
    btw, forgot to add this: You can use Google (www.google.com) to search for Normalization and related topics; I guess you can find some good sites/literature online too.


  4. #4
    Join Date
    Mar 2002
    Location
    Toronto
    Posts
    13
    Thanks Manish.

    I found a useful article on normalization that others may be interested in, or may wish to comment on;

    http://www.phpbuilder.com/columns/barry20000731.php3

  5. #5
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74
    Originally posted by catch
    Thanks Manish.

    I found a useful article on normalization that others may be interested in, or may wish to comment on;

    http://www.phpbuilder.com/columns/barry20000731.php3

    That really is a good article to start with. Infact, I suggest using www.phpbuilder.com as your first place to search for articles on PHP+SQL development.

Posting Permissions

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