Database Modeling and Design Logical Design [Paperback]

Database Modeling and Design, Fifth Edition, focuses on techniques for database design in relational database systems.

This extensively revised fifth edition features clear explanations, lots of terrific examples and an illustrative case, and practical advice, with design rules that are applicable to any SQL-based system. The common examples are based on real-life experiences and have been thoroughly class-tested.

This book is immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data. It is ideal for a stand-alone data management course focused on logical database design, or a supplement to an introductory text for introductory database management.

• 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

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

The database professional's only complete business intelligence guide to data modeling concepts and logical database design

Database systems and database design technology have seen significant changes in recent years. The relational data model and relational database systems dominate applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining.lS-