This book is intended for IT professionals and students who want to learn
how to design, analyze, and understand databases. The material will benefit
those who want a better high-level understanding of databases such as
proposal managers, architects, project managers, and even customers. The
material will also benefit those who will actually design, build, and work
with databases such as database designers, database administrators, and
programmers. In many projects, these roles overlap so the same person may be
responsible for working on the proposal, managing part of the project, and
designing and creating the database.
Table Of Contents:
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.
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.