Database Modelling and Design: Entity Relationship Approach - Softcover

Teorey, Toby J.

Softcover

ISBN 10: 1558601341 ISBN 13: 9781558601345

Publisher: Morgan Kaufmann Publishers In, 1990

Synopsis

This new edition of Database Modeling & Design continues to focus on the techniques for relational database design introduced in previous editions, starting with the entity-relationship (ER) approach for data requirements specification and conceptual modeling. Author Toby Teorey then looks ahead to the common properties in data modeling and operations shared among the relational model and advanced database technologies such as the object-oriented, temporal, and multimedia models. A full chapter is devoted to database design techniques for data warehousing and online analytical processing (OLAP).

Teorey covers the database life cycle from requirements analysis and logical design to physical design for local, distributed, and multidatabases. The discussion of basic principles is supplemented with a common, running example: a company personnel and project database based on real-life experiences and classroom testing.

Written for both the novice and the professional database designer, this book is the essential resource for database modeling, including the building of standard SQL data definitions. The design rules set forth in this book are applicable to any SQL-based system, including IBM DB2, Oracle V8.0, Informix IDS-UDO, Microsoft Access, Microsoft SQL Server, and Sybase Adaptive Server Enterprise.

* Continued focus on relational model
* Integration of information about data warehouse and OLAP, plus other advanced database technologies, including object oriented, multimedia, and temporal database
* Discussion of basic principles is supplemented by examples based on real life cases

About this title

From the Author

This book is for database developers and administrators.
As the author of "Database Modeling and Design" I am pleased to make some comments on the practical use of the book. Relational databases have made a big impact on information technology, and it looks like they will be doing so for at least another decade as the dominant technology, especially for corporate and personal databases. This is a book for the database developer or database administrator with at least some background in programming and the basics of relational databases. In fact, 80% of its sales has been to professionals and managers of IT. It has also been successfully used to supplement textbooks for courses in relational databases.

The reader should be aware that this book is not an introductory text for relational databases and is not for the novice as a first exposure to databases. However, if you want to be able to take a database concept from inception to implementation, this is the right book. It's fun to use and it gets you to your goal with minimum hassles.

About the Author

Toby J. Teorey is a professor in the Electrical Engineering and Computer Science Department at the University of Michigan, Ann Arbor. He received his B.S. and M.S. degrees in electrical engineering from the University of Arizona, Tucson, and a Ph.D. in computer sciences from the University of Wisconsin, Madison. He was general chair of the 1981 ACM SIGMOD Conference and program chair for the 1991 Entity-Relationship Conference. Professor Teorey’s current research focuses on database design and data warehousing, OLAP, advanced database systems, and performance of computer networks. He is a member of the ACM and the IEEE Computer Society.

Edition details

• Publisher: Morgan Kaufmann Publishers In
• Publication date: 1990
• ISBN 10: 1558601341
• ISBN 13: 9781558601345
• Binding: Paperback
• Language: English
• Number of pages: 288