Database Management Systems Sem III (Mumbai Univ)

ISBN Number : 978-93-5367-500-4

Student Price : Rs.125

Student Dollar Price : 5$

Book Edition : First

Year of Publication : 2019

No. Of Pages : 140

About The Book

It gives us immense pleasure to present this First Edition of "Database Management System" to the teachers and students of Bachelor of Computer Science, Second Year, Third Semester. This book has been written as per the syllabus prescribed by the University with effect from academic year 2017-18.

Information is a valuable resource to an organization. Computer software provides an efficient means of processing information, and database systems are becoming increasingly common means by which it is possible to store and retrieve information in an effective manner. This book provides comprehensive coverage of fundamentals of database management system. This book is for those who wish a better understanding of relational data modeling, its purpose, its nature, and the standards used in creating relational data model. Relational databases are the most popular database management systems in the world and are supported by a variety of vendor implementations. Majority of the practical tasks in industry require applying relatively not complex algorithms to huge amounts of well-structured data. The efficiency of the application depends on the quality of data organization. Advances in database technology and processing offer opportunities for using information flexibility and efficiently when data is organized and stored in relational structures. The relational DBMS is a success in the commercial marketplace with respect to business data processing and related applications. This success is a result of cost-effective application development combined with high data consistency. The success has led to the use of relational DBMS technology in other application environments requesting its traditional virtues, while at the same time adding new requirements.

Chapter 1 describes introduction to data and database. Unit 1 describes stored procedures, sequences, triggers and file organization with indexing. Unit 2 describes about PL/SQL. Other chapters describes transaction of DBMS and cash recovery.

The concept and theory of each topic is followed by the theoretical explanation and some self assessment questions. All practical solutions of RDBMS SQL commands are provided.


Contents -

Unit I
1. Stored Procedures
2. Triggers
3. Sequences
4. File Organization and Indexing
Unit II
5. Fundamentals of PL/SQL
6. Overview of PL/SQL Control Structures
Unit III
7. Transaction Management
8. DCL Statements
9. Crash Recovery

About The Author

Prof. Kiran Gurbani, is currently Head of Computer Science, Department of R.K. Talreja College of Arts, Science & Commerce. She started journey of teaching from the year 1994 from Jondhale Engineering College, CDAC Center of Pune and Mumbai and later joined R.K.T. College. Subsequently, working for Post Graduate M.Sc. Computer Science and Information Technology and Professor in number of premium colleges. Overall 17+ years of experience as a Trainer / Academic In-charge / SME on varied technology platform.

She is a professor from last 17 years for various technologies, object oriented C++, Java, Visual Basic, DoT Net (VB.NET and ASP.NET), Unix shell scripting, Linux Administration, Oracle, SQL, Cloud Computing, Virtualization and Cloud management, web technologies, Software Engineering, Software testing, JBOSS and Web Logic, Parallel and Distributed computing, ADBMS, C# and Internet Technologies.

She is freelancer corporate trainer for the companies–Capgemini, Oracle, c-Edge, seed, CDAC for Unix shell scripting with Ant Technology, Linux, Cloud and Software Engineering (SSAD,OOAD), Networking CCNA and Middleware. She is a Guest faculty for ICWA, MMS Systems and Technologies and M.Sc. Computer Science and Information technology.

She has conducted several workshops and seminars for students and faculties of all over Mumbai. She is Freelancer trainer in various premium colleges of Mumbai and Thane for Troubleshooting of Linux for undergraduate and postgraduate and performed mini projects on Domain creation and uploading website of a company through apache web server, Mini project on Samba server for sharing Windows and Linux machines with Authenticated Users, Mini project of handling data and creating groups, users and authenticate them through Shell scripts of Linux. She is resource person in the training programs for organisations and premium colleges at University Level.

She is Leading as a Project Guide for Final Year Students of Undergraduate and Postgraduate for .NET & Android & Cloud management. She published books on Visual Basic, C++ Programming, Linux Operating System, Java and Data Structures.

She has published several papers:
(1) Different ICT Devices
(2) Problems Faced by Women’s in Career-building
(3) Different Mechanisms of Cloud Storage
(4) OpenStack Private Cloud with GitHub
(5) Probabilistic Independence Virtualization Database with NOSQL Database System Analysis in Bigdata.

Jhalak Nitin Makhija is a Lecturer in Computer Science Department at Smt. Chandibai Himathmal Mansukhani College, Mumbai University. She has the teaching experience of around 8 years. She has taught various subjects such as Database Management Systems, Discrete Mathematics, Artifical Intelligence, Sensor Networks, etc.

Mrs. Raveena Shetty Tilak is information technology graduate and holds a degree of Masters in Information Technology from Mumbai University. She has been teaching information technology subject at undergraduate and postgraduate level for last 3 years and she has experience in corporate of 1 year.

Book Reviews

Login Form