Database Systems (Mumbai Univ)

ISBN Number : 978-93-5273-452-8

Student Price : Rs.230

Student Dollar Price : 9$

Book Edition : First

Year of Publication : 2017

No. Of Pages : 256

Book Weight :326

About The Book

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

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. Chapters 2, 3, 4 and 5 describes Data Models, ER Models, Normalization and Data Models. Chapters 6 to 15 describes Relational Algebra, DDL, DML, DCL, functions, sub-queries, views and data protection with DBA.

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

 

Contents -

UNIT I
1. Introduction to DBMS
2. Data Models
3. Entity Relationship Model
4. Relational Data Model
5. ER to Table
UNIT II
6. Schema Refinement and Normalization
7. Relational Algebra
8. DDL Statements
9. DML Statements
UNIT III
10. Functions
11. Joining Tables
12. Subqueries
13. Database Protection
14. Views
15. DCL Statements
Practicals of Database Systems

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. Rupali Jawale is currently working as a Lecturer in Department of Information Technology in S.D.T. Kalani College of Arts, Science & Commerce.  She has an overall 4+ years of teaching experience for various technologies like Imperative Programming, Digital Electronics, OOPs with C++, ASP.NET (with C# & VB), ADBMS and Software Testing.
She is also working as Project Guide for final year Undergraduate students.

Ms. Madhuri S. Bankar has over 11 years of experience in teaching. She is currently associated with KBP College, Vashi as Assistant Professor. Her area of specialization is Database Management System and quantitative techniques. She has written 3 international research papers and done 2 minor research projects. She conducts workshops and seminars on Information Technology and related area and delivers expert lectures on Database Management.

Book Reviews

Login Form
Username:
Password: