This book provides a comprehensive coverage of the fundamentals of “database management systems” where the theoretical concepts are explained in an easy-to-understand manner while according equal weightage to the practical aspect of the subject. The principles of database management systems are dealt in depth here.
The various approaches to data models, relative advantages of relational models are expressed in detail and the “entities, different types of entities, attributes and relationships” are discussed with relevant examples and E-R diagrams. The concept of “Normalization”, its forms and its constraints are dealt keeping in mind for a students’ preparation for their examinations. The Lingua Franca of database world SQL includes “DDL, DML and DCL commands” and the same are explained with syntaxes and suitable examples including Joins, Indexes and Table Handling Techniques. The student will now have a clear understanding of topics like “Transactions and Concurrency Management” as these are explained elaborately with necessary examples. To cater to the needs of the students, an attempt has been made to give them clarity on “Distributed and Client-server Databases”.
Contents –
1. Basic Concepts
2. Database Integrity and Normalisation
3. Structured Query Language (SQL)
4. Transactions and Concurrency Management
5. Distributed and Client-Server Databases
LAB: SQL QUERIES BASED ON VARIOUS COMMANDS
