Beginning Database Design (Wrox Beginning Guides) by Gavin Powell (Dec 5, 2005)
Database design is the best way to structure the tables and queries used with databases in order to provide optimum performance, storage, management and flexibility. With relational databases, you can use tables to organize data and retrieve information from your database. This book provides an easy to understand explanation of the design and modeling of relational database to do just that.
The step by step numerous examples and a useful case study simplify a potentially complex subject and present it to you in an organized and understandable. You will notice that standard relational database was necessary, first, and how they developed the model of relational database. Ultimately, you will discover how to make better use of its database by applying what you have learned about constructing the model database.
Database design is the best way to structure the tables and queries used with databases in order to provide optimum performance, storage, management and flexibility. With relational databases, you can use tables to organize data and retrieve information from your database. This book provides an easy to understand explanation of the design and modeling of relational database to do just that.
The step by step numerous examples and a useful case study simplify a potentially complex subject and present it to you in an organized and understandable. You will notice that standard relational database was necessary, first, and how they developed the model of relational database. Ultimately, you will discover how to make better use of its database by applying what you have learned about constructing the model database.
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