Database Management System
About The Book Database Management System by Bhavesh Pandya
This book provides an introduction to the concepts of Database Management System for second year engineering students of Computers and Information Technology. It is written considering the syllabus of Mumbai University, laying emphasis on E-R Model, Relational Algebra, SQL queries, Integrity, Security, Database design, Transaction management, Query processing and PL/SQL.
Database is an integral part required to understand the backend of any technology. It is among the core technical subjects for the students of Computer and Information Technology, which would not only help them for placements but also in the industry to further work on any platform
The book is self-contained. The chapters are written in a very simple language with a lot of example and exercises. The book also contains large number of figures and tables to explain the concepts in a better way. The book fills the gap between theoretical learning and practical implementation of concepts of databases for IT Professionals and Engineers.
Audience of the Book :
|Database Management System (As per III semester IT Syllabus of University of Mumbai|
The main features of the book are as follows:
1. Large number of application oriented problem statements and review exercises along with their solutions are provided for hands on practice.
2. Includes 12 University Question paper for IT department (Dec '08 - May '14) with solutions to provide an overview of University Question pattern.
3. Lab manual along with desired output for queries is provided as per recommendations by Mumbai University.
4. All the SQL queries mentioned in the book are performed and applicable for Oracle DBMS tool.
Table of Contents:
1.Introduction to Database Concepts
2.Entity-Relationship Data Model
3.Relational Model and Algebra
4.Structured Query Language
5.Integrity and Security in Database
6.Integrity and Security in Database
7.Transactions Management and Concurrency
8.Query Processing and Optimization