Database Management Systems

This is a comprehensive and student-friendly textbook presents the fundamental concepts necessary for designing, using and implementing database systems and applications.

Part I – Introduction: Data, Information and Information Processing
Secondary (Auxiliary) Storage Devices
Files, File Organization and Files Structures
Indexing and Hashing
Software Development Life Cycle (SDLC) and Database Development Life Cycle (DDLC) Information to Relational Database Management Systems (RDBMS)

Part II – Database Architecture, Design and Data Modeling Database Architecture and Data Modeling Entity-Relationship (E-R) Modeling Enhanced Entity-Relationship (EER) Model Data Normalization Part III – Query Languages: Relational Algebra and Relational Calculus Tables Used in this Book Introduction to Structured Query Language (SQL) Tables, Views and Indexes Nulls Queries and Subqueries Aggregate Functions Insert, Update and Delete Operations Cursors Joins and Unions Programming with SQL Query-by-Example (QBE) QUEL Triggers Query processing and Optimization Part IV – Database Implementations Issues Database Security Data Integrity Transaction Management and Concurrency Control Backup and Recovery Part V – Database Technologies: Evolution of Computing Models Client/Server Technology and Client/Server Database Distributed Database Multidimensional Data and Database Parallel Processing and Parallel Database Spatial and Multimedia Database Mobile Computing and Mobile Database Web Database Part VI – Database Applications: Knowledge Discovery in Database (KDD) Data Warehousing and Data Marts Data Mining On-Line Transaction Processing (OLTP) On-Line Analytical Processing (OLAP) Customer Relationship Management (CRM) Supply Chain Management (SCM) Geographic Information System (GIS) Part VII – Appendices