|
|
|
|
DESCRIPTION
|
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.
|
|
CONTENTS
|
|
Preface
Chapter 1. Introduction to Relational Database Systems
Chapter 2. Structured Query Language
Chapter 3. Database Design
Chapter 4. Query Processing
Chapter 5. Transaction Processing
Chapter 6. Databases and XML
Chapter 7. Database Cases
Chapter 8. SQL Labs
Appendices
Index
|
|
ABOUT THE AUTHOR(s)
|
MARGARET BERNARD, Ph.D., is Senior Lecturer with the Department of Computer Science and the Deputy Dean (Graduate Studies and Research), with the Faculty of Science and Technology, The University of the West Indies. She has been in the profession of teaching at university level for more than three decades. Dr. Bernard has taught courses in Database systems at both undergraduate and postgraduate levels at the University of West Indies, St. George’s University in Grenada and at the University of Central Florida in USA. She is also the lead investigator in a research project, ‘AgriNeTT’ which focuses on Open Data and building mobile apps for farmers. She has contributed chapters in the books based on computer technology in education. She has also received an award in the Software Systems category under the “Prime Ministers’ Awards for Innovation and Invention”. Dr. Bernard is also a member of the Caribbean Academy of Sciences and UWI representative on LACCIR (Latin America and Caribbean Collaborative ICT Research).
Her research interest includes E-learning and Educational Data Mining.
ESHWAR BACHU, is with the Department of Computer Science, University of West Indies. With wide teaching experience at undergraduate and postgraduate levels, he has developed and instructed professional short courses which prepare individuals to write professional Oracle Certification exams. He has also contributed chapters in the book based on computer technology.
|
| |
|
|
2015 / 220pp. / 17.8 × 23.5 cm / ISBN-978-81-203-5145-5 / Rs.395.00
|
| |
|
|
|
|
