Fundamentals of Database Management Systems (Sem 1, BSc IT Mumbai Univ)

ISBN Number : 978-93-5840-210-0

Student Price : Rs.280

Student Dollar Price : 11$

Book Edition : First

Year of Publication : 2024

No. Of Pages : 226

Book Weight :318

About The Book

It gives us immense pleasure to present this First Edition of “Fundamentals of Database Management Systems” to the teachers and students of Bachelor of Information Technology, First Year, First Semester. This book has been written as per the syllabus prescribed by the University with effect from academic year 2022-23.

Information is a valuable resource to an organisation. 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 modelling, 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 organisation. Advances in database technology and processing offer opportunities for using information flexibility and efficiently when data is organised 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 Normalisation. Other Chapters describes transaction of DBMS.

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 Database System-Concept and Architecture
Unit II Database Design, ER Diagram, and UML
Unit III Relational Database Model
Unit IV Introduction to SQL and File Structure
Unit V Transaction Management, Concurrency Control, and Recovery
Practical Manual

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.

Dr. Irfan Lakhani is an Associate Professor at Anjuman–I–Islams Allana Institute of Management Studies, Mumbai. He is having overall 23 years of experience in the industry, academia, and research. He was working with International Steel Corp. (steel traders and importers) as a Senior Executive. He has also worked with renowned bank auditors as an Audit Officer. He is currently a recognized Ph.D. guide from the University of Mumbai and a PG research supervisor at UCAM University, Murcia, Spain and amp; at Guglielmo Marconi University (GMU), Rome, Italy. He has a Ph.D. in Management Studies, M.F.M., M.Com., and M.A. in Philosophy from the University of Mumbai. He has published more than 20 research papers in National and International Journals and he has also completed various short-term programs from the University of Luxembourg, National Institute of Securities Market, IIM Kozhikode, Calcutta Business School, AMU, etc.

Prof. Ahtesham Shaikh is the Head of the Department – IT at Anjuman-i-Islams Akbar Peerbhoy College of Commerce and Economics, Mumbai. He has done his MCA, MBA (Information Systems), Microsofts MTSF and Google Certification. He is having 15 years of teaching and industry experience. He has presented and/or published 12 National and International Research Papers, including an award-winning paper at the International Conference on Business Intelligence. He is associated as a Visiting Faculty with 13 colleges for B.Sc. IT, B.Sc. CS, BMS, MMS, MCA and M.Sc. IT.

Asst. Prof. Binita Thakkar is a Research Scholar, Head of Department (B.Sc. Information Technology) and Assistant Professor at VIVA College of Arts, Commerce and Science, Virar (W).

She has done her M.Sc. (IT) from University Department of Information Technology, Kalina and is currently pursuing Ph.D. in Computers and Systems Sciences. She has also presented and/or published 5 National and International Research Papers. She is also working as a Program Committee Member and Reviewer at International Conferences. She has published 2 books and is also a Course Content Writer for University of Mumbai.

Prof. Ansari M. Nasir is the Head of the Department — IT, at P. D. Hinduja Trusts, K. P. B. Hinduja College, Mumbai. He has done his MCM, MBA (Information Systems), M.Phil. in Computer Science and is doing his Ph.D. from University of Mumbai. He has presented and/or published 23 National and International Research Papers.

Book Reviews

Login Form
Username:
Password: