Database Management Systems

ISBN Number : 978-93-5273-978-3

Library Price : Rs.1280

Library Dollar Price : 51$

Book Edition : First

Year of Publication : 2018

No. Of Pages : 352

About The Book

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 wellstructured 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. Chapters 2, 3 and 4 describes Data Models, ER Models and Normalization. Other Chapters describes transaction of DBMS.

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

 

Contents -

1. Introduction to Databases and Transactions
2. Data Models
3. Database Design, ER Diagram and UML
4. Relational Database Model
5. Relational Algebra
6. Relational Calculus
7. Constraints, Views and SQL
8. Transaction Management and Concurrency
9. PL – SQL
DBMS Practicals
ER and UML Case Studies

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.

Mrs. Jayalakshmi Srinivasan, Assistant Professor, HOD, B.Sc. IT Dept., V.E.S. College of Arts, Science and Commerce, Chembur, has been service as a teacher since 1999. C programming, Object Oriented Programming Languages such as CPP, Java and C#, Database Management System, Advanced DBMS, Dot Net Technologies, Web Technologies, Internet Technologies and mobile computing are her expertise.

She presented and published research papers in several National and International conferences. Twice, she received "Best Research Paper" award. She published papers in International Journals. She had written SLM (Self Learning Material) for IDOL, University of Mumbai for B.Sc. IT and MCA students in the subject of Network Security, ASP.NET, DCN and CRM. She published several books for the students of B.Sc. IT, B.Sc. CS, BMS and BFM. She was conferred with "Shiksha Rattan Puraskar" by IIFS, Delhi.

Prof. Bhavini Deepak Shah is currently working as a coordinator of B.Sc. IT and M.Sc. IT department in SIES College of Commerce and Economics, Sion East. She has more than 9 years of experience in teaching Computer Science and Information Technology subjects at junior, graduate and post graduate level. Various subjects include Network Security, Data Warehousing, Database Management Systems, Advanced SQL, Modern Operating Systems, Introduction to C++, Java and Data Structures, Quantitative Techniques, Computational Mathematics, Green Computing, Microprocessor and Microcomputer, Artificial Intelligence and Advanced Database Management Systems.

She has presented several papers in National and International journals. She is currently working under Minor Research Project on E-waste Recycling, granted by University of Mumbai.

Book Reviews

Login Form
Username:
Password: