|

Addison-Wesley / Prentice Hall

Computer Science

My Instructor Resource Center :  Log in or request access

Fundamentals of Database Systems/Oracle 9i Programming, 4/E
Ramez ElmasriUniversity of Texas at Arlington
Shamkant B. NavatheGeorgia Institute of Technology
Rajshekhar SunderramanGeorgia State University

ISBN-10: 0321206746
ISBN-13:  9780321206749

Publisher:  Addison-Wesley
Copyright:  2004
Format:  Cloth Package
Published:  07/23/2003
We're sorry, this product is no longer available and has been replaced with Fundamentals of Database Systems, 6/E.

Please contact your Pearson rep if you are using this product and need instructor resources.

Fundamentals of Database Systems has become the world-wide leading textbook because it combines clear explanations of theory and design, broad coverage of models and real systems, and excellent examples with up-to-date introductions and modern database technologies. This book has been revised and updated to reflect the latest trends in technological and application development. This fourth edition expands on many of the most popular database topics, including SQL, security, and data mining along with an introduction to UML modeling and an entirely new chapter on XML and Internet databases.

  • The market-leading text for both a first and follow-on database course.
  • Features an extensive table of contents that includes basic topics (modeling, diagrams, relational algebra/calculus, SQL, normalization) and advanced object database, toning, mining, XML, and security.
  • Famous for its clear and complete writing style.
  • Renowned for its combinational theory, examples, and exercises which provide the foundational knowledge on topics.
  • Covers advanced modeling in the areas of active, temporal, and spatial databases.
  • Provides coverage of issues on physical database design and tuning.
  • Discusses current database application areas of GIS, genome, and digital libraries.
  • Presents a clear and complete discussion of the relational approach, including modeling, design, algebra and calculus, and query languages.
  • Each new copy comes with free access to Addison-Wesley's Database Place. Database Place helps students master the key concepts of all database courses. It includes online tutorials that help students with their mastery of modeling, SQL, and data normalization. Each tutorial asks students to solve problems (such as writing an SQL query, drawing a diagram, or normalize a relation), and then provides useful feedback based on the student's solution.

  • Provides new and expanded PowerPoints for professors.
  • Now covers both the traditional ER model and UML when discussing data modeling.
  • Includes updated material on SQL, including a new chapter, which discusses topics from SQL programming including SQLJ, JDBC, and ODBC.
  • Applies ideas from the book to a fully developed case study that uses a step-by-step database design and implementation for a bookstore application.
  • Offers updated coverage of security and database tuning.
  • Features a new chapter on the relationship of XML and Internet databases keeps students on the edge of database technology.
  • Includes a new chapter on data mining.

I. INTRODUCTION AND CONCEPTUAL MODELING.

 1. Databases and Database Users.

 2. Database System Concepts and Architecture.

 3. Data Modeling Using the Entity-Relationship Model.

 4. Enhanced Entity-Relationship and UML Modeling.

II. RELATIONAL MODEL: CONCEPTS, CONSTRAINTS, LANGUAGES, DESIGN, AND PROGRAMMING.

 5. The Relational Data Model and Relational Database Constraints.

 6. Relational Algebra and Relational Calculus.

 7. Relational Database Design by ER- and EER-to-Relational Mapping.

 8. SQL99-Schema Definition, Constraints, and Queries.

 9. More SQL-Assertions, Views, and Programming Techniques.

III. DATABASE DESIGN THEORY AND METHODOLOGY.

10. Functional Dependencies and Normalization for Relational Databases.

11. Relational Database Design Algorithms and Further Dependencies.

12. Practical Database Design Methodology Using UML.

IV. DATA STORAGE, INDEXING, QUERY PROCESSING, AND PHYSICAL DESIGN.

13. Disk Organization, Basic File Structures, and Hashing.

14. Indexing Structures for Files.

15. Algorithms for Query Processing and Optimization.

16. Physical Database Design and Tuning.

V. TRANSACTION PROCESSING CONCEPTS.

17. Introduction to Transaction Processing Concepts and Theory.

18. Concurrency Control Techniques.

19. Database Recovery Techniques.

VI. OBJECT AND OBJECT-RELATIONAL DATABASES.

20. Object Database Concepts.

21. The ODMG Standard for Object Databases.

22. Object-Relational Systems and SQL3.

VII. FURTHER TOPICS.

23. Database Security, Authorization, and Encryption.

24. Enhanced Data Models for Advanced Applications.

25. Distributed Databases and Client-Server Architectures.

VIII. EMERGING TECHNOLOGIES.

26. Internet Databases and XML.

27. Data Warehousing and Data Mining Concepts.

28. Emerging Database Technologies and Applications.

Appendix A. Alternative Diagrammatic Notations for ER models.

Appendix B. Database Design and Application Implementation Case Study.

(New appendix on the Web including a detailed database design case study).

Appendix C. Parameters of Disks (old Appendix B).

Appendix D. The QBE Language (old section 9.5).

Appendix E. Hierarchical Data Model (old Appendix C dropped - moved to Web).

Appendix F. Network Data Model (old Appendix D dropped - moved to Web).

Bibliographic References.

Index.

DatabasePlace Website
Addison Wesley Higher Education
©2003 | Addison-Wesley | Website | Instock
ISBN-10: 0321160088 | ISBN-13: 9780321160089
Online purchase price: $18.00

DatabasePlace Website
Addison Wesley Higher Education
©2003 | Addison-Wesley | Website | Instock
ISBN-10: 0321160088 | ISBN-13: 9780321160089
Online purchase price: $18.00

Online Appendices, B, E, and F, 4/E
Elmasri & Navathe
©2004 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321360761 | ISBN-13: 9780321360762
    View Downloadable Files

Online Book Figures PowerPoints, 4/E
Elmasri & Navathe
©2004 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321360753 | ISBN-13: 9780321360755
    View Downloadable Files

Online PowerPoints, 4/E
Elmasri & Navathe
©2004 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321205774 | ISBN-13: 9780321205773
    View Downloadable Files

Online Solution's Manual, 4/E
Elmasri & Navathe
©2004 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321359178 | ISBN-13: 9780321359179
    View Downloadable Files

Case Study on Design and Implementation, 4/E
Elmasri & Navathe
©2004 | Addison-Wesley | Electronic Supplement | Instock
ISBN-10: 0321360729 | ISBN-13: 9780321360724


DatabasePlace Website
Addison Wesley Higher Education
©2003 | Addison-Wesley | Website | Instock
ISBN-10: 0321160088 | ISBN-13: 9780321160089
Online purchase price: $18.00

DatabasePlace Website
Addison Wesley Higher Education
©2003 | Addison-Wesley | Website | Instock
ISBN-10: 0321160088 | ISBN-13: 9780321160089
Online purchase price: $18.00

Log in to the Instructor Resource Center

Login name: 

  Password: 

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

         

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.