Database Systems With Case Studies

Download Database Systems With Case Studies PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Database Systems With Case Studies book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages.
DATABASE SYSTEMS WITH CASE STUDIES

Author: BERNARD, MARGARET
language: en
Publisher: PHI Learning Pvt. Ltd.
Release Date: 2015-10-04
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.
Relational Database Design Clearly Explained

Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you'll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS. Supporting the book's step-by-step instruction are three case studies illustrating the planning, analysis, and design steps involved in arriving at a sound design. These real-world examples include object-relational design techniques, which are addressed in greater detail in a new chapter devoted entirely to this timely subject. * Concepts you need to master to put the book's practical instruction to work. * Methods for tailoring your design to the environment in which the database will run and the uses to which it will be put. * Design approaches that ensure data accuracy and consistency. * Examples of how design can inhibit or boost database application performance. * Object-relational design techniques, benefits, and examples. * Instructions on how to choose and use a normalization technique. * Guidelines for understanding and applying Codd's rules. * Tools to implement a relational design using SQL. * Techniques for using CASE tools for database design.
INTRODUCTION TO DATA MINING WITH CASE STUDIES

Author: GUPTA, G.K.
language: en
Publisher: PHI Learning Pvt. Ltd.
Release Date: 2014-06-28
The field of data mining provides techniques for automated discovery of valuable information from the accumulated data of computerized operations of enterprises. This book offers a clear and comprehensive introduction to both data mining theory and practice. It is written primarily as a textbook for the students of computer science, management, computer applications, and information technology. The book ensures that the students learn the major data mining techniques even if they do not have a strong mathematical background. The techniques include data pre-processing, association rule mining, supervised classification, cluster analysis, web data mining, search engine query mining, data warehousing and OLAP. To enhance the understanding of the concepts introduced, and to show how the techniques described in the book are used in practice, each chapter is followed by one or two case studies that have been published in scholarly journals. Most case studies deal with real business problems (for example, marketing, e-commerce, CRM). Studying the case studies provides the reader with a greater insight into the data mining techniques. The book also provides many examples, review questions, multiple choice questions, chapter-end exercises and a good list of references and Web resources especially those which are easy to understand and useful for students. A number of class projects have also been included.