Database Principles and Development: SQL Server + PowerBuilder

Author: Li Jianyi
Publisher:
Publish Date: 2005-05-14
Features: Adopts a "task-driven" writing approach, introducing case-based heuristic teaching methods; provides teaching resources such as electronic lesson plans and case materials, offering a three-dimensional for textbooks; meets the training needs of applied talents in higher education institutions. This book takes the purpose of applied undergraduate education as its starting point, adhering to the principle of sufficient theory and strong practicality, and introduces the theory and application methods of relational database design in a concise, clear, and easy-to-understand manner. The theoretical part of the book explains the basic theories of relational databases in the SQL Server 2000 development environment, while the application part takes the development process of the "Contract Tracking Management System" as an example, incorporating the author's years of teaching and research experience. It introduces how to design and develop a database management system using PowerBuilder 9.0, integrating the theory and application of database principles. The book is rich in content, well-structured, and highly practical. It is divided into 14 chapters, covering the following main topics: Database System Overview, Relational Database Theory, Structured Query Language (SQL), Database Security and Maintenance, Database System Design, Modern Database Systems, PowerBuilder Overview, Database and Manipulation in PowerBuilder, Application Objects, PowerScript Language, Window Objects, Data Windows, Menu Design, and Application Project Debugging and Distribution. The book is rich in content, well-structured, and highly practical. It is divided into 13 chapters, covering the following main topics: Database System Overview, Relational Database Theory, Structured Query Language (SQL), Database Security and Maintenance, Database System Design, PowerBuilder Overview, ASA Database Design, Application Objects, PowerScript Language, Window Objects, Data Windows, Menu Design, and Application Project Debugging and Distribution. This book is suitable as a textbook for universities and colleges on databases and can also be referenced by database system developers. The book is accompanied by an electronic lesson plan and provides all program source codes. To facilitate course teaching and self-study, the author has also written a supporting experimental guide. Readers can contact the author (lijy@nciae.edu.cn) to obtain relevant teaching documents or download them from the China Water Conservancy and Hydropower Press website at http://www.waterpub.com.cn/softdown/.