Database Principles and Application Case Tutorial

Author: Shou Jianxia
Publisher:
Publish Date: 2005-09-01
Features: This book is written based on the author's practical teaching experience, adhering to the overall approach of a solid foundation, emphasis on skills, and pursuit of innovation. It follows the principles of practicality and sufficiency, highlighting the characteristics of vocational and technical education in terms of content selection, teaching methods, and the support of experiments and practical training. Through studying this book, students can establish a comprehensive knowledge system of database principles and applications and master practical techniques of database systems. The content of this book includes:
● Basic concepts of database systems
● Relational database standard language SQL
● Database design
● Database security and protection
● SQL reference on-the-spot experiments
Features of the book:
■ Foundational
The content is rich, well-structured, and highly readable. Each knowledge point is explained in simple language, with a narrative style that emphasizes reviewing what has been learned and connecting it to new concepts, allowing students to grasp and integrate the material flexibly.
■ Practical
To make database principles more accessible, the book adopts a "case-driven" teaching model, with almost every chapter using practical cases to illustrate related concepts and operations. These cases progress from simple to complex, gradually deepening, making them easier for students to understand and master. Additionally, a comprehensive large-scale example system is integrated throughout the book.
■ Systematic
The book is accompanied by complete supplementary materials. Instructors using this book as a textbook can download from the China Machine Press website: answers to exercises, complete source code for cases and experiments (all verified through hands-on testing), and beautifully designed PPT teaching materials for reference.
The book uses the popular SQL Server 2000 as the experimental platform to explain basic concepts of database systems, relational models, SQL language and development platforms, logical design and normalization of databases, and database security and protection. Each chapter includes exercises, and the appendix provides hands-on experiments for SQL language and an example database system. All cases, exercises, and experiments in the textbook offer complete, hands-on-verified program documentation for download, while also providing PPT electronic teaching materials for instructors.
This book explains database principles through cases, with clear concepts and highlighted key points, making it suitable as a textbook for database principles and applications courses in national demonstration software vocational colleges, vocational and technical colleges, and adult education institutions. It is also ideal as a self-study textbook and reference book. For undergraduate students from non-computer majors who wish to learn key and practical database technologies, this book can also be used as a textbook.