Beginning Database Design (repost)

Database design involves how to best structure the tables and queries that are used with databases in order to provide optimum performance, storage, manageability, and flexibility. With relational databases, you can use those tables to organize your data and retrieve information from your database. This book provides you with an easy-to-understand explanation of designing and building relational database models to do just that.

The numerous step-by-step examples and a helpful case study simplify a potentially complex subject and present it to you in an organized, understandable manner. You'll find out why relational database models became necessary in the first place, and how the relational database model was devised. Ultimately, you'll discover how to make much better use of your database by applying what you've learned about building the database model.

What you will learn from this book:
Basic concepts of relational database modeling
The components of a relational database model
Making normalization easier to use
Advanced relational database modeling
How to improve relational database model performance
Describing tables during using analysis (WHAT needs to be solved)
Refining tables and relationships using design (HOW to provide solutions)
How to read and write data with SQL
Create relational database models by applying business rules