Database systems : a pragmatic approach / Elvis C. Foster, with Shripad Godbole

Includes index

1. Introduction to Database Systems2. The Database System EnvironmentPart B: The Relational Database Model3. The Relational Model4. Integrity Rules and Normalization5. Database Modeling and Design6. Database User Interface Design7. Relational Algebra8. Relational Calculus9. Reflective Look at the Relational Database ModelPart C: The Structured Query Language10. Overview of SQL11. SQL Data Definition Statements12. SQL Data Manipulation Statements13. Logical Views and System Security14. The System Catalog15. Some Limitations of SQLPart D: Advanced Topics16. Database Administration17. Distributed Database Systems18. Object Databases19. Data Warehousing20. Web-Accessible Databases21. Using Database Systems to Anchor Management Support SystemsPart E: Overview of Selected DBMS Suites22. Overview of Oracle23. Overview of DB224. Overview of MySQL25. Overview of Microsoft SQL ServerPart F: Appendices26. Appendix 1: Review of Trees27. Appendix 2: Review of Hashing28. Appendix 3: Review of Information Gathering Techniques29. Appendix 4: BNF Syntax for Selected SQL Statements 30. Appendix 5: Sample Exercises and Examination Questions.

Available to OhioLINK libraries

This book provides a comprehensive, yet concise introduction to database systems, with special emphasis on the relational database model. The book discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. New in this second edition is updated SQL content covering the latest release of the Oracle Database Management System along with a reorganized sequence of the topics which is more useful for teaching. Also included are revised and additional illustrations, as well as a new chapter on using relational databases to anchor large, complex management support systems. There is also added reference content in the appendixes. The book is based on lecture notes that have been tested and proven over several years, with outstanding results. It also exemplifies mastery of the technique of combining and balancing theory with practice, to give students their best chance at success. The book discusses concepts, principles, design, implementation, and management issues of databases. Each chapter is organized systematically into brief, reader-friendly sections, with itemization of the important points to be remembered. It adopts a methodical and pragmatic approach to solving database systems problems. Diagrams and illustrations also sum up the salient points to enhance learning. Additionally, the book includes a number of Elvis Foster's original methodologies that add clarity and creativity to the database modeling and design experience, while making a novel contribution to the discipline. These features combine to make Database Systems: A Pragmatic Approach an excellent textbook for students and reader-friendly resource on database theory for the practitioner.