Skip To Page Navigation|Skip To Page Content

Addison-Wesley / Prentice Hall

Computer Science

My Instructor Resource Center : Log in or request access

DataBase Systems: A Practical Approach to Design, Implementation and Management, 4/E
Thomas M. Connolly, University of Paisley
Carolyn E. Begg, University of Paisley

ISBN-10: 0321294017
ISBN-13: 9780321294012

Publisher: Addison-Wesley
Copyright: 2005
Format: Paper; 1400 pp
Published: 06/10/2004

This book places a strong emphasis on good design practice, allowing students to master design methodology in an accessible, step-by-step fashion. A clear introduction to design implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable complete reference for database students and professionals. The book is designed to be used in database courses for technical and non-technical students.

To visit the companion website, please click here: http://www.booksites.net/connbegg/.

Uses UML notation for ER diagrams.

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 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, ISP, and Oracle's PSP.

Thorough update of later chapters covering object oriented databases, web databases, XML, data warehousing, data mining.

Features greater interaction on the companion Web site, including multiple choice questions for each chapter.

Includes access to an online tool that allows students to run database queries against their own database, and a downloadabe ER editor that utilizes the UML notation and allows students to create their own ER diagrams.

More links to web resources. New end of chapter exercises and exam questions.

I. BACKGROUND.

1.Introduction to Databases.

2. Database Environment.

II. THE RELATIONAL MODEL AND LANGUAGES.

3. The relational model.

4. Relational algebra and relational calculus.

5. SQL: data manipulation.

6. SQL: data definition.

7. Query-By-Example (QBE).

8. Commercial DBMSs: Access and Oracle.

III. DATABASE ANALYSIS AND DESIGN TECHNIQUES.

9. Database planning, design and administration.

10. Fact-finding techniques.

11. Entity-relationship modeling.

12. Enhanced entity-relationship modeling.

13. Normalization.

14. Advanced normalization.

IV. METHODOLOGY.

15. Methodology - conceptual database design.

16. Methodology - logical database design for relational model.

17. Methodology - physical database design for relational databases.

18. Methodology - monitoring and tuning the operational system.

V. SELECTED DATABASE ISSUES.

19. Security.

20. Transaction management.

21. Query processing.

22. Programming SQL.

VI. DISTRIBUTED DBMSs AND REPLICATION.

23. Distributed DBMSs - concepts and design.

24. Distributed DBMSs - advanced concepts.

25. Replication and mobile databases.

VII. OBJECT DBMSs.

26. Introduction to Object DBMSs.

27. Object-oriented DBMSs - concepts and design.

28. Object-oriented DBMSs - standards and languages.

29. Object-relational DBMSs.

VIII. WEB AND DBMSs.

30. Web technology and DBMSs.

31. Semistructured data and XML.

IX. BUSINESS INTELLIGENCE (OR DECISION SUPPORT).

32. Data warehousing concepts.

33. Data warehousing design.

34. OLAP.

35. Data mining.

APPENDICES.

A. Users' requirements specification for Dreamhome case study.

B. Other case studies.

C. File organization and storage structures.

D. When is a DBMS relational?

E. Programmatic SQL.

F. Alternative data modeling notations.

G. Summary of the database design methodology for relational databases.

H. Estimating disk space requirements.

I. Example web scripts.

Database Systems: Advanced Topics (Computer Science)
Database Systems & Design (Computer Science)

Database Systems: A Practical Approach to Design, Implementation and Management, 5/E
Connolly & Begg
©2010 | Addison-Wesley | Paper; 1400 pp | Instock
ISBN-10: 0321523067 | ISBN-13: 9780321523068
Net price: $96.00 (What's this?)Brief Description

This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases—conceptual, logical, and physical database design.

The Fifth Edition brings Web and legal issues to the fore in two new chapters, Database Architectures and the Web and Professional, Legal, and Ethical Issues. Students are exposed not only to the foundational theory of databases but also to the most recent developments in the field.

This book is ideal for a one- or two-term course in database management or database design in an undergraduate or graduate level course. With comprehensive coverage, this book can also be used as a reference for IT professionals.
Instructor's Solutions Manual for Database Systems: A Practical Approach to Design, Implementation and Management, 5/E
Connolly & Begg
©2009 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321523075 | ISBN-13: 9780321523075
Powerpoint Slides for Database Systems: A Practical Approach to Design, Implementation and Management, 5/E
Connolly & Begg
©2009 | Addison-Wesley | Online Study Guide | Instock
ISBN-10: 0321523083 | ISBN-13: 9780321523082

Database Systems Companion Website: A Practical Approach to Design, Implementation and Management, 4/E
Connolly & Begg
©2005 | Addison-Wesley | On-line Supplement; 0 pp | Instock
ISBN-10: 0131215655 | ISBN-13: 9780131215658
View Downloadable Files

Database Systems 4 Ed Instructors Manual on the Web, 4/E
Connolly & Begg
©2006 | Addison-Wesley | On-line Supplement; 538 pp | Instock
ISBN-10: 0273704133 | ISBN-13: 9780273704133
View Downloadable Files

Database Systems PowerPoints on the Web: A Practical Approach to Design, Implementation and Management, 4/E
Connolly & Begg
©2004 | Addison-Wesley | On-line Supplement; 160 pp | Instock
ISBN-10: 0131215647 | ISBN-13: 9780131215641
View Downloadable Files

Password:

Forgot login/password? | Need to redeem an access code?

We're sorry!

We don't recognize your login or password. Please go back.

If you continue to experience problems, please try the following:

Retrieve your login or password
Contact Technical Support
Request IRC access

close window

Your access will expire soon.

To ensure uninterrupted service, you should renew your access for this site soon.

Renew now or proceed without renewing

close window

We're sorry!

Your access to the Instructor Resource Center has expired.

To continue using the IRC, renew your access now.

Some Internal Error occured. Please try again.

Instructor Resource Center File Download

This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.

Cancel

I accept, proceed with download

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.