Description
Vikas Publishing House Database Management System: (For University Of Mumbai) by BHAVESH PANDYA, SAFA HAMDARE & ASIM KUMAR SEN
Written Strictly as per Mumbai University syllabus, this book provides a complete guide to the theoretical as well as the practical implementation of DBMS concepts including E-R Model, Relational Algebra, SQL queries, Integrity, Security, Database design, Transaction management ,Query processing and Procedural SQL language. This book assumes no prior knowledge of the reader on the subject. Introduction to Database Concepts • Entity-Relationship Data Model • Relational Model and Algebra • Structured Query Language • Integrity and Security in Database • Relational -Database Design and Normalization • Transactions Management and Concurrency • Query Processing and Optimization Large number of application oriented problem statements and review exercises along with their solutions are provided for hands on practice.
• Includes 12 University Question paper for IT department (Dec '08 - May '14) with solutions to provide an overview of University Question pattern.
• Lab manual along with desired output for queries is provided as per recommendations by Mumbai University.
• All the SQL queries mentioned in the book are performed and applicable for Oracle DBMS tool.