Database Design, Application Development, and Administration

Rating:
Summary: concentrate on making a good design
Review: Manning gives you a good exposition of the important ideas in putting together a database. The theory of relational databases is explained in enough detail that you should be able to apply this to your situation. Laying out whichever tables you need, in a judicious fashion, can take some skill. But by moving your data around, you should be able to find a suitable configuration of several tables, and the appropriate keys and foreign keys to connect these together.

The other portions of the book, which discuss actually coding this, and on being a database administrator, are also important. But the conceptually hardest parts relate to the initial design. And it is here that you should focus your efforts.