The Book strictly follows the syllabus of west Bengal University of Technology (WBUT)
A large number of solved examples are given for understanding the topics
A variety of multiple choice question and answer in each chapter is given
Solutions of university Question papers according to the chapters are given at the end of the each chapter
Table Of Contents Chapter 1 : Concept And Overview of DBMS
1.1 Introduction
1.2 Disadvantage of file system
1.3 Data Models
1.4 Three Schema Architecture
1.5 Data Independence
1.6 Database Users
1.7 Database Administration
1.8 Database Languages
1.9 Summary
1.10 Solved examples
1.11 Model question
Chapter 2 : Entity Relationship Model
2.1 Introduction
2.2 Basic concepts
2.3 Design issues
2.4 Constraints
2.5 The Entity Relationship Diagram
2.6 Extended ER Features
2.7 Summary
2.8 Solved Examples
2.9 Model Question
Chapter 3 : Relational Algebra & calculus
3.1 Introduction
3.2 Structure of Relational Databases
3.3 Relational Algebra
3.4 Enterded Relational Algebra
3.5 The Tuple Relational Calculus
3.6 The Domain Relational Calculus
3.7 Modifying The Database
3.8 Summary
3.9 Solved Examples
3.10 Model Questions
Chapter 4 : SQL
4.1 Introduction
4.2 Schema Definition in SQL
4.2 Basic Queries in SQL
4.3 Set Operation
4.5 Aggregate Functions
4.6 Null Values
4.7 Nested Sub queries
4.8 Derived Relations
4.9 Understanding PL/SQL Block Structure
4.10 Integrity constraints
4.11 Modification of the Database
4.12 Join types and conditions
4.13 Summary
4.14 Solved examples
4.15 Model Questions
Chapter 5 : Normalization
5.1 Introduction
5.2 The Database of Modification Anomalies
5.3 Useful Definitions
5.4 Properties of Functional Dependencies
5.5 First Normal Form (INF)
5.6 Second Normal Form (2NF)
5.7 Third Normal Form (3NF)
5.8 BCNF (Boyee -Codd Normal Form)
5.9 Multivalued dependencies
5.10 Fourth Normal Form
5.11 Dependency Preservation
5.12 Lossless decomposition
5.13 Fifth Normal form
5.14 DKNF (Domain Key Normal Form
5.15 Summary
5.16 Solved Examples
5.17 Model Question
Chapter 6 : Transaction, Concurrency Control And Recovery
6.1 Introduction
6.2 Query Optimizer
6.3 Transaction Processing
6.4 Database locking
6.5 Recovery: the transaction log
6.6 Summary
6.7 Solved Examples
6.8 Model Questions
Chapter 7 : File Organization & Index Structure
7.1 Introduction
7.2 File & Record Concept
7.3 Magnetic Disks
7.4 Fixed-Length Records
7.5 Variable-Length Records
7.6 Records on Disks: Spanned v/s Unspanned
7.7 Single-Level ordered Indexes
7.8 Multilevel Indexes
7.9 Summary
7.10 Solved examples
7.11 Model Questions
Read More
Specifications
Book
WBUT Data Base Management System
Author
Himadri Nath Saha
Binding
Paperback
Publisher
Systech Education
Language
English
Ratings & Reviews
3.3
★
3 Ratings &
1 Reviews
5★
4★
3★
2★
1★
1
1
0
0
1
5
best book for Database management System for everyone
i am very much grateful to the author for writing this book. this book is very helpful specially for WBUT students. All the explanation are very precise and very clear to understand.
Mainly Normalization ,Transaction and Relational Algebra portion is very good.