This book is a comprehensive, practical, and student-friendly textbook addressing fundamental concepts in database design and application. It covers one full semester course on database systems offered to undergraduate (BE, B.Tech. BCA, B.Sc.), postgraduate (ME, M.Tech., MCA, MBA, M.Sc.), and diploma students of computer science and engineering, information technology, and software engineering. This book also serves as a trainer for various short- and long-term computer courses as well as a reference for practicing engineers and IT professionals.
Features
- Comprehensive coverage of topics with flexible organization and logical flow.
- Simple language with real world examples, illustrative figures and exercises.
- Easy-to-use, step-by-step methodologies for conceptual and logical database designs covering functional dependency, decomposition, normalization, relational algebra, relational calculus, query processing and optimization.
- Advance and emerging database concepts such as parallel databases, distributed database management, decision support systems, data warehousing and data mining, Web-enabled databases, mobile databases, multimedia databases, spatial databases, and digital libraries.
- Chapters on commercial databases, namely, DB2 Universal Databases, Microsoft SQL Server, Oracle, Microsoft Access and MySQL to help the student in visualizing practical and real-time implementation of database system.
- Rich in pedagogy—contains review questions, multiple choice questions with answers at the end of each chapter.
- Bridges the gap between theory and practical implementation of database concepts for business applications through a large number of case studies.
Contents DATABASE CONCEPTS
Introduction to Database System
Database System Architecture
Physical Data Organisation
RELATIONAL MODELS
Relational Algebra Calculus
Relational Query Languages
Entity Relational (E-R) Model
Enchanced Entity- Relationship (EER) Model
DATABASE DESIGN
Introduction to Database Design
Functional Dependency and Decomposition
Normalization
TRANSACTION AND SECURITY MANAGEMENT
Query Processing and Optimization
Transaction Processing and Concurrency Control
Database Recovery System
Database Security
OBJECT-BASED DATABASES
Object-Oriented Database
Object-Relational Database
ADVANCE AND EMERGING DATABASE CONCEPTS
Parallel Database Systems
Distributed Database Systems
Decision Support Systems (DSS)
Data Warehousing and Data Mining
Emerging Database Technologies
CASE STUDIES
Database Design – Case Studies
COMMERCIAL DATABASES
IDM DB2 Universal Database
Oracle
Microsoft SQL Server
Microsoft Access
MySQL
