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

Author: Zhu Rulong
Publisher:
Publish Date: 2004-01-01
Features: This book is divided into 3 chapters. The first chapter is the exercise solutions, including all the answers to the exercises provided with the accompanying textbook "SQL Server Database Application System Development Technology." The second chapter is the experimental guide, starting from the basic creation of databases and table objects, it gradually guides students to establish other database objects, implement data integrity, create queries, views, indexes, triggers, stored procedures, and perform database backup and recovery. There are 14 experiments in total, matching the textbook, with each experiment corresponding to a specific topic. Students can complete them in order or select based on their specific circumstances. The third chapter is the course design guide, including an example of the hotel management system course design and topic selection for the salary management system and the book management system. The course design example provides the complete 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. This book is a supplementary textbook for "SQL Server Database Application System Development Technology."