1st Edition

Database Systems
A Pragmatic Approach, 3rd edition



  • Available for pre-order. Item will ship after April 6, 2022
ISBN 9781032217321
April 6, 2022 Forthcoming by Auerbach Publications
376 Pages 179 B/W Illustrations

USD $180.00

Prices & shipping based on shipping country


Preview

Book Description

This textbook is ideally suited for an undergraduate course in database systems. The discipline of database systems design and management is discussed within the context of a bigger picture — that of software engineering. The student is made to understand from the outset, that a database is a mission-critical component of a software system; that databases systems often form part of an organization’s information infrastructure; and that proper database design and management is integral to the success of its related software engineering project and/or its related organizational information infrastructure.

Table of Contents

I. Preliminary Topics
1. Introduction to Database Systems
2. The Database System Environment

II. The Relational Database Model
3. The Relational Model
4. Integrity Rules and Normalization
5. Database Modeling and Design
6. Database User Interface Design
7. Relational Algebra
8. Relational Calculus
9. Reflective Look at the Relational Model

III. Structured Query Language (SQL)
10. Overview of SQL
11. SQL Definition Statements
12. SQL Data Manipulation Statements
13. Logical Views and Security
14. The System Catalog
15. Some Limitations of SQL

IV. Advanced Topics
16. Database Administration
17. Distributed Database Systems
18. Object Databases
19. Data Warehousing and Information Extraction
20. Web-Accessible Databases
21. Using Relational Databases to Anchor Management support Systems

V. Overview of Contemporary DBMS Suites and Technologies
22. Overview of Oracle
23. Overview of DB2
24. Overview of MySQL
25. Overview of SQL Server
26. Other Emerging Database Methodologies

VI. Appendices
A. Review of Trees
B. Review of Hashing
C. Review of Information Gathering Techniques
D. BNF Syntax for Selected SQL Statements
E. Sample Exercises and Examination Questions

...
View More

Author(s)

Biography

Elvis C. Foster is a Professor of Computer Science at Keene State College. He holds a Bachelor of Science (BS.) in Computer Science and Electronics, as well as a Doctor of Philosophy (PhD) in Computer Science (specializing in software engineering and database systems) from University of the West Indies, Mona Jamaica. His research interests include the development as well as evaluation of management support systems for contemporary organizations.

Shripad V. Godbole is an independent database administrator and consultant with more than 20 years of experience in diverse business environments, information infrastructure planning, diagnostics, and administration. He is also the Vice President for Technology Management at State Street Global Advisors, Boston. His qualifications include Bachelor of Science (BS) in Physics, Bachelor of Computer Science (BCS), Master of Science (MS) in Physics with specialization in Electronics, all from Poona University in Pune, India. He is also an Oracle Certified Professional Database Administrator (OCPDBA) and holds a Master of Business Administration (MBA) in Technology Management from University of Phoenix.