Database Modeling and Design
- Toby Teorey, University of Michigan, Ann Arbor, USA
- Sam Lightstone, IBM, Toronto, Canada
- Tom Nadeau, Ubiquiti Inc., Ann Arbor, MI
- H.V. Jagadish, Univ of Mich, Ann Arbor (EE/CS dept)
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, youll 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 youll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems.
This book is intended for data management professionals with job titles/functions that include data analyst, data modeler; data architect; database designer; database application developer, application architect, database programmer, programmer/analyst, database administrator.
Paperback, 352 Pages
Published: February 2011
Imprint: Morgan Kaufmann
Database Modeling and Designis one of the best books that I have seen for explaining how to build database applications. The book is informative, well-written, and concise."-Michael Blaha, DSc., Consultant, Modelsoft Consulting Corp"This book book is by far the best book available on classic database design. Topics like normalization and many-to-many and n-ary association semantics are without peer in teaching you how to model real-world complexities. This latest edition extends the classic material with extensive discussion of modern tools and other aspects of logical database design. Every database architect should have this book at hand."-Bob Muller, Data Analyst, Poesys AssociatesThe book is not only good for beginners, but it also provides greater insight for experienced learners. Perhaps this is why it has evolved into its fifth edition. The book is generally well organized. It starts with the first step in the database life cycle, and progresses in a chronological order to more advanced concepts such as object relational design, Extensible Markup Language (XML), and Web databases. The writing style of the book is simple and straightforward, and the use of database terminology is very concise In my opinion, the book could be used as a course text, with some help from other sources to cover SQL query-related concepts. However, I would have liked a chapter on SQL that covered simple and complex query design, as well as optimization."-- Computing Reviews
1. Introduction2. The Entity-Relationship Model3. Unified Modeling Language (UML)4. Requirements Analysis and Conceptual Modeling
5. Transforming the Conceptual Data Model to SQL6. Normalization
7. An Example of Logical Database Design8. Object Relational Design
9. XML and Web Databases10. Business Intelligence
11. CASE Tools
Appendix: The Basics of SQL