Beginning Database Design Solutions
Published on 15. April 2009
552 pages
978-0-470-44051-3 (ISBN)
Available for download
Description
The vast majority of software applications use relational databasesthat virtually every application developer must work with.This book introduces you to database design, whether you'rea DBA or database developer. You'll discover what databases are,their goals, and why proper design is necessary to achieve thosegoals. Additionally, you'll master how to structure the database soit gives good performance while minimizing the chance for error.You will learn how to decide what should be in a database to meetthe application's requirements.
More details
Other editions
Additional editions
Rod Stephens
Beginning Database Design Solutions
Book
10/2008
1st Edition
Wrox Press
Unfortunately, price unknown
Article exhausted; check for reprint
Content
I. Introduction to Databases and Database Design.
1. Golas of Effective Database Design.
2. Database Types.
3. Relational Database Fundamentals.
II. Database and Design Process Techniques.
4. Understanding User Needs.
5. Translating User Needs Into Data Models.
6. Extracting Business Rules.
7. Normalizing Data.
8. Designing Databases to Support Software Applications.
9. Common Design Patterns.
10. Common Design Pitfalls.
III. A Detailed Case Study.
11. User Needs and Requirements.
12. Building a Data Model.
13. Building a Relastional Model.
14. Extracting Business Rules.
15. Normalization and Refinement.
16. Microsoft Access.
17. MySQL.
IV. Advanced Topics.
18. Introdution to SQL.
19. Building Databases with SQL Scripts.
20. Databse Elements.
21. Database Security.
Appendix A. Exercise Solutions.
Appendix B. Sample Database Designs.
Appendix C. Glossary.
Index.
1. Golas of Effective Database Design.
2. Database Types.
3. Relational Database Fundamentals.
II. Database and Design Process Techniques.
4. Understanding User Needs.
5. Translating User Needs Into Data Models.
6. Extracting Business Rules.
7. Normalizing Data.
8. Designing Databases to Support Software Applications.
9. Common Design Patterns.
10. Common Design Pitfalls.
III. A Detailed Case Study.
11. User Needs and Requirements.
12. Building a Data Model.
13. Building a Relastional Model.
14. Extracting Business Rules.
15. Normalization and Refinement.
16. Microsoft Access.
17. MySQL.
IV. Advanced Topics.
18. Introdution to SQL.
19. Building Databases with SQL Scripts.
20. Databse Elements.
21. Database Security.
Appendix A. Exercise Solutions.
Appendix B. Sample Database Designs.
Appendix C. Glossary.
Index.
