Conceptual Database Design: An Entity-Relationship Approach [Paperback]

Carol Batini (Author), Stefano Ceri (Author), Shamkant B. Navathe (Author)

Book Description

ISBN-10: 0805302441 | ISBN-13: 978-0805302448 | Publication Date: August 17, 1991 | Edition: 1

This comprehensive book is written to meet the needs of database designers, programmers, and end-users interested in maximizing the power of conceptual and logical design using the entity-relationship approach. The authors, internationally know experts in the field, thoroughly examine conceptual design, functional analysis, and logical design with an emphasis on issues related to the user and the application. The text presents a unique step-by-step design methodology that incorporates state-of-the art software engineering and database design techniques and includes a large, realistic case study that illustrates key concepts. A capstone chapter, written by Dr. David Reiner, provides a survey of database design tools including basic tools for conceptual and logical design and current commercial database design and CASE Tools. Features *Teaches how to conceptualize, design, reverse engineer, or modify large relational, network, or hierchical database systems. *Introduces and explains concepts and their implementations using a step-by-step methodology that is accessible to database designers, end-users, and application programmers.* Emphasizes the entity-relationship model throughout, including coverage of generalization hierarchies, set-subset relationships, and a variety of semantic constraints. *Integrates functional analysis with data analysis to show how to create an integrated database environment for a variety of reasons. *Examines reverse mapping into E-R schema for the relational, network, and hierarchical models. *Illustrates how to implement design techniques through a large, realistic case study/application. *Provides an up-to-date survey and analysis of existing database design tools. 0805302441B04062001

Editorial Reviews

From the Back Cover

This comprehensive book is written to meet the needs of database designers, programmers, and end-users interested in maximizing the power of conceptual and logical design using the entity-relationship approach. The authors, internationally know experts in the field, thoroughly examine conceptual design, functional analysis, and logical design with an emphasis on issues related to the user and the application. The text presents a unique step-by-step design methodology that incorporates state-of-the art software engineering and database design techniques and includes a large, realistic case study that illustrates key concepts. A capstone chapter, written by Dr. David Reiner, provides a survey of database design tools including basic tools for conceptual and logical design and current commercial database design and CASE Tools.

Features

• Teaches how to conceptualize, design, reverse engineer, or modify large relational, network, or hierchical database systems.
• Introduces and explains concepts and their implementations using a step-by-step methodology that is accessible to database designers, end-users, and application programmers.
• Emphasizes the entity-relationship model throughout, including coverage of generalization hierarchies, set-subset relationships, and a variety of semantic constraints.
• Integrates functional analysis with data analysis to show how to create an integrated database environment for a variety of reasons.
• Examines reverse mapping into E-R schema for the relational, network, and hierarchical models.
• Illustrates how to implement design techniques through a large, realistic case study/application.
• Provides an up-to-date survey and analysis of existing database design tools.

0805302441B04062001

About the Author

About Carlo Batini

Carlo Batini is a professor of computer science at Universitá degli Studi di Roma "La Sapienza." His major areas of research include conceptual database design, database integration, automatic layout of diagrams, and user-friendly query languages. He is the author of several books on programming languages, relational theory, and databases

Stefano Ceri is a Professor of Database Systems and project manager for the Esprit project, IDEA, at the Politecnico di Milano. His research interests include data distribution, deductive and active rules and object-orientation. He is a member of the VLDB and EDBT Endowments and has contributed to various international journals and conference proceedings as an author and on the editorial board.

Shamkant Navathe is a professor and the head of the database research group at the College of Computing, Georgia Institute of Technology, Atlanta. He is well-known for his work on database modeling, database conversion, database design, distributed database allocation, and database integration. He has worked with IBM and Siemens in their research divisions and has been a consultant to various companies including Digital,CCA, HP and Equifax. He was the General Co-chairman of the 1996 International VLDB (Very Large Data Base) conference in Bombay, India. He was also program co-chair of SIGMOD 1985 and General Co-chair of the IFIP WG 2.6 Data Semantics Workshop in 1995. He has been an associate editor of ACM Computing Surveys, and IEEE Transactions on Knowledge and Data Engineering. He is also on the editorial boards of Information Systems (Pergamon Press) and Distributed and Parallel Databases (Kluwer Academic Publishers). He is an author of the book, Fundamentals of Database Systems, with R. Elmasri (Addison Wesley) which is currently the leading database text-book worldwide. He also co-authored the book Conceptual Design: An Entity Relationship Approach (Addison Wesley, 1992) with Carlo Batini and Stefano Ceri. His current research interests include human genome data management,intelligent information retrieval, data mining and warehousing, web-based knowledge warehouses and mobile database synchronization. Navathe holds a Ph.D. from the University of Michigan and has over 100 refereed publications.

0805302441AB04062001

Product Details

• Paperback: 470 pages
• Publisher: Addison Wesley; 1 edition (August 17, 1991)
• Language: English
• ISBN-10: 0805302441
• ISBN-13: 978-0805302448
• Product Dimensions: 9.5 x 7.6 x 1 inches
• Shipping Weight: 2.1 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #1,264,940 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

8 of 9 people found the following review helpful:

5.0 out of 5 stars Best Database Design book ever, March 9, 2001

By 

André Granville (Rio de Janeiro, Brazil) - See all my reviews

This review is from: Conceptual Database Design: An Entity-Relationship Approach (Paperback)

Following my teacher's recommendation, I bought this book for a class I had on Conceptual Database Design. This book is a masterpiece on data modeling, covering conceptual, logical and phisical database design in a clear and direct way. One of the bests parts of the book are the plenty exercises on the end of each chapter. I highly recommend this book for anyone who wants to be a serius database designer.

1 of 1 people found the following review helpful:

4.0 out of 5 stars on the way down to conceptual design, August 15, 2011

By 

Davide Melan "D." (Italy) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Conceptual Database Design: An Entity-Relationship Approach (Paperback)

The book is a very detailed explanation of the ER model, though it lacks of some mathematical formalisms.

Each chapter is completed by exercises and a terrific annotated bibliography.

Part One describes the model and gives a methodology about design. Examples are provided, maybe, representations of instances like in section 3.4 of Elmasri, Navathe, Fundamentals of Database Systems are missing, unless referring to Chen's paper.

Part Two completes the design by the functional analysis; definitely helpful is chapter 10.

Part Three takes to the logical design and reverse engineering for relational, network, and hierarchical models.

Chapter 15 is of course outdated.