Database Systems with Case Studies, covers exactly what students needs to know in an introductory database system course. This book focuses on database design and exposes students to a variety of approaches for getting the Data Model right. The book addresses issues related to database performance (Query Processing) and Transaction Management for multi-user environments. This book also introduces non-relational XML format to students. The approach taken to teach the topics is through introduction of many real-world enterprise database case studies and practice problems. The case studies are selected based on modern application areas, keeping the student’s interest in mind. The book provides hands-on experience of database design issues with several ready-made lab exercises. For grading students’ understanding of the topics, several challenging assignments are also provided at the end of chapters. Multiple-choice self-tests are provided for formative assessment throughout the book.

The book is suitable for the undergraduate students of Computer Science and Engineering, Information Technology, and students of Computer Applications (BCA/MCA).

Key features

• All the topics are illustrated with practical examples.

• Topics like Entity-Relationship diagram (ERD), are discussed with Diagrams and Visual Aids.

• Students are exposed to the various approaches for determining data requirements.

• Structured Query Language (SQL) examples are worked with scripts, results and solutions.

• Exclusive lab exercises on SQL, can be used as assignments.