SQL Server 2005 Database Application System Development Technology Experiment Guide and Exercise Solutions

Author: Zhu Rulong
Publisher:
Publish Date: 2006-07-01
Features: This book is a supplementary textbook for "SQL Server 2005 Database Application System Development Technology." The book is divided into three chapters. The first chapter is the solution to the exercises, including all the answers to the exercises provided with the supplementary textbook "SQL Server 2005 Database Application System Development Technology." The second chapter is the experimental guide, starting from the basic creation of database and table objects, gradually guiding students to establish other database objects, implement data integrity, create queries, views, indexes, triggers, stored procedures, and perform database backups and recoveries. There are 14 experiments in total, with the textbook, each corresponding to a specific topic. Students can complete them in order or select them based on their specific circumstances. The third chapter is the course design guide, including an example of a hotel management system course design and two topic selections: a salary management system and a library management system. The course design example provides all the SQL scripts and VB program code for the design. All the code in this example has been debugged, compiled, and executed by us, and can be used as a reference during course design. The book is richly illustrated, clearly explained, and the operational steps are well-defined, making it very convenient for readers to read and understand.