ABSTRACT
This book provides a concise but comprehensive guide to the disciplines of database design, construction, implementation, and management. Based on the authors’ professional experience in the software engineering and IT industries before making a career switch to academia, the text stresses sound database design as a necessary precursor to successful development and administration of database systems. The discipline of database systems design and management is discussed within the context of the bigger picture of software engineering. Students are led to understand from the outset of the text that a database is a critical component of a software infrastructure, and that proper database design and management is integral to the success of a software system. Additionally, students are led to appreciate the huge value of a properly designed database to the success of a business enterprise.
The text was written for three target audiences. It is suited for undergraduate students of computer science and related disciplines who are pursuing a course in database systems, graduate students who are pursuing an introductory course to database, and practicing software engineers and information technology (IT) professionals who need a quick reference on database design.
Database Systems: A Pragmatic Approach, 3rd Edition discusses concepts, principles, design, implementation, and management issues related to database systems. Each chapter is organized into brief, reader-friendly, conversational sections with itemization of salient points to be remembered. This pragmatic approach includes adequate treatment of database theory and practice based on strategies that have been tested, proven, and refined over several years. Features of the third edition include:
- Short paragraphs that express the salient aspects of each subject
- Bullet points itemizing important points for easy memorization
- Fully revised and updated diagrams and figures to illustrate concepts to enhance the student’s understanding
- Real-world examples
- Original methodologies applicable to database design
- Step-by-step, student-friendly guidelines for solving generic database systems problems
- Opening chapter overviews and concluding chapter summaries
- Discussion of DBMS alternatives such as the Entity–Attributes–Value model, NoSQL databases, database-supporting frameworks, and other burgeoning database technologies
- A chapter with sample assignment questions and case studies
This textbook may be used as a one-semester or two-semester course in database systems, augmented by a DBMS (preferably Oracle). After its usage, students will come away with a firm grasp of the design, development, implementation, and management of a database system.
TABLE OF CONTENTS
part Section A|32 pages
Preliminary Topics
chapter Chapter 1|12 pages
Introduction to Database Systems
chapter Chapter 2|18 pages
The Database System Environment
part Section B|164 pages
The Relational Database Model
chapter Chapter 3|34 pages
Introducing the Relational Model
chapter Chapter 4|30 pages
Integrity Rules and Normalization
chapter Chapter 5|36 pages
Database Modeling and Design
chapter Chapter 6|16 pages
Database User Interface Design
chapter Chapter 7|24 pages
Relational Algebra
chapter Chapter 8|16 pages
Relational Calculus
chapter Chapter 9|6 pages
Reflective Look at the Relational Database Model
part Section C|138 pages
The Structured Query Language
chapter Chapter 10|6 pages
Overview of SQL
chapter Chapter 11|36 pages
SQL Data Definition Statements
chapter Chapter 12|52 pages
SQL Data Manipulation Statements
chapter Chapter 13|20 pages
Logical Views and System Security
chapter Chapter 14|14 pages
The System Catalog
chapter Chapter 15|8 pages
Some Limitations of SQL
part Section D|88 pages
Advanced Topics
chapter Chapter 16|12 pages
Database Administration
chapter Chapter 17|12 pages
Distributed Database Systems
chapter Chapter 18|6 pages
Object Databases
chapter Chapter 19|14 pages
Data Warehousing
chapter Chapter 20|12 pages
Web-Accessible Databases
chapter Chapter 21|30 pages
Using Database Systems to Anchor Management Support Systems
part Section E|48 pages
Overview of Selected DBMS Suites and Technologies