Database Solutions: A Step-by-Step Approach to Building Databases

Part 1 Background Introduction The relational model The database application lifecycle Part 2 Database analysis and design techniques Fact-finding Entity-Relationship modeling Normalization Part 3 Logical database design Overview of the methodology Logical database design Step 1 Logical database design Step 2 Logical database design Step 3 Advanced modeling techniques Part 4 Physical database design Physical database design Step 4 Physical database design Step 5 Physical database design Step 6 Physical database design Step 7 Physical database design Step 8 Sample StayHome queries using SQL and QBE Part 5 Second worked example Perfect Pets Logical database design Perfect Pets Physical database design What next? Appendices Appendix A Alternative data modeling notations Appendix B Summary of the database design methodology Appendix C File organizations and indexes Appendix D Common data models Glossary References Index