Look Inside

Database Management Systems

1,280.00

SKU: 7de9d3e2c420 Category:

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

ISBN

Student Dollar Price
Library Dollar Price

51

Pages

352

Edition

First

Year of publication

2018

Weight
Type

Author

Bhavini D. Shah,

Jayalakshmi Srinivasan,

Kiran Gurbani

Publisher

Himalaya pub