PDA

View Full Version : Database Design Literature

catch
03-05-02, 02:26
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.
Manish
03-05-02, 07:43
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.
Manish
03-05-02, 07:45
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.

:)
catch
03-06-02, 14:37
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
Manish
03-08-02, 08:37
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. :)