Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs? In the extensively revised fifth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems. In-depth detail and plenty of real-world, practical examples throughout Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data. Read more... 1. Introduction 2. The Entity-Relationship Model 3. Unified Modeling Language (UML) 4. Requirements Analysis and Conceptual Modeling 5. Transforming the Conceptual Data Model to SQL 6. Normalization 7. An Example of Logical Database Design 8. Object Relational Design 9. XML and Web Databases 10. Business Intelligence 11. CASE Tools Appendix: The Basics of SQL