It gives us immense pleasure to present this First Edition of “Database Management System” to the teachers and students of Bachelor of Information Technology, 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. 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 self assessment 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