Database System Experiment Guide

Author: Shan Jiankui
Publisher:
Publish Date: 2004-12-01
Features: This book is written by the author based on years of experience in teaching database courses and conducting research, to meet the teaching needs of the "Database Principles and Applications" course. It is designed to accompany the selected textbook "Introduction to Database Systems" (3rd Edition). The book consists of 5 basic experiments, 2 comprehensive experiments, and 3 appendices. The experimental part mainly includes: the installation and configuration of SQL Server 2000, database creation and management, table creation and management, data manipulation, data querying, database protection (including database recovery, concurrency control, database security, and database integrity), and preliminary development of data application systems using the PowerBuilder 9.0 development tool. The appendices include: T-SQL programming basics and the creation and management of stored procedures and triggers, the PowerBuilder database application development environment, and a recommended outline for the "Database Principles and Applications" course design. The content of this book is presented in a step-by-step, easy-to-understand manner and can serve as a supplementary experimental textbook for undergraduate and junior college computer-related majors taking the "Database Principles and Applications" course. It can also be used as a reference for candidates preparing for self-study examinations.