Database Systems: A Practical Approach to Design, Implementation, and Management

Front Cover
Addison-Wesley, 2002 - Computers - 1236 pages
5 Reviews
"Database Systems'" practical, hands-on approach makes it uniquely suited to providing a strong foundation in good database design practice. A clear introduction to design, implementation and management issues, as well as an extensive treatment of database language and standards, make this book an indispensable complete reference for database students and professionals alike. The new edition of this bestseller brings it up to date with the latest developments in database technology and builds on the clear, accessible approach that contributed to the success of previous editions.

A realistic case study integrated throughout the book enables complex subjects to be explained in the context of one understandable example, while three additional case studies allow readers to work through examples by themselves. Clearly stated chapter objectives and summaries guide the reader, highlighted key definitions and numerous worked examples illustrate the concepts, and review questions and exercises reinforce the material covered in each chapter. Features Database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice. Extensive treatment of SQL in three tutorial-style chapters. Comprehensive treatment of distributed, object-oriented, and object-relational DBMSs. Comprehensive introduction to data warehousing, OLAP, and data mining. Extensive treatment of the Web as an emerging platform for database applications with many code samples for accessing databases from the Web including JDBC, SQLJ, ASP, JSP, and Oracle's PSP. New! For the third edition Use ofUML notation for ER diagrams. New chapter on the relational algebra and relational calculus. New chapter on fact-finding techniques as a step prior to the start of the database design methodology. New chapter on Access and Oracle DBMSs, illustrating the difference between the two systems. New chapter on semistructured data, its relationship to XML, and query languages for XML. New chapter of data warehouse design using dimensionality modeling. Introduction of color to highlight the text and improve navigation through the book. Additional Web resources at, such as prototype implementations of the case studies, and lab notes for Access.

From inside the book

What people are saying - Write a review

User ratings

5 stars
4 stars
3 stars
2 stars
1 star

User Review - Flag as inappropriate

It is utterly wrong to say that it should be named an SQL book and that that is all it's about. I have read this book before and it teaches database design techniques and tells you about the pitfalls you should avoid. It also teaches you normalization up till the 5th Normal Form (i.e. 1NF, 2NF, 3NF, BCNF, 4NF and 5NF) which is pretty much a lot for most database manuals, since most stuff I find only cover up till 3NF. Also, it is pretty structured and a good read for those new to the subject. Seeing that I have gone though this book even when I was new to the subject of databases, if you do not understand it, it is not so much the fault of the book but rather that of the reader not spending enough effort in understanding the concepts that the book contains. So please, don't blame the book if you lack the effort. I say effort because I am trying to be polite and do not want to bring ability into question. I do not mean any offense to anyone, but recklessly hammering away at a good and useful book just because you don't understand it is like cursing people because you don't understand their point of view even though their point of view holds many merits. Please, do not discourage others from reading this book when it, although perhaps not being the best book around, is still rather good and better still, structured. 

Review: Database Systems: A Practical Approach to Design, Implementation and Management

User Review  - Amr - Goodreads

I'm not a database designer but when I had to design a database I used the book as a reference. I found good theoretical base with rich examples that had a great value to me. I didn't read the whole book by the way. Read full review


The Relational Model
Database Environment

60 other sections not shown

Other editions - View all

Common terms and phrases

References to this book

All Book Search results »

About the author (2002)

Both Thomas Connolly and Carolyn Begg have experience of database design in industry, and now apply this in their teaching and research at the University of Paisley in Scotland. Thomas Connolly has significant industrial experience, and was a designer of RAPPORT, the world's first commercial portable DBMS, and of the LIFESPAN configuration management tool - a winner of the British Design Award. He has recently launched a couple of eBusiness companies from the University. Carolyn Begg specialises in the application of database systems in biological research.

Bibliographic information