Database Principles and Applications

Author: Zhang Jinlian
Publisher:
Publish Date: 2004-07-01
Features: Database technology is currently the fastest-developing and most widely applied technology in the field of computer science. Its applications span across various industries, from large-scale systems such as operating system programs, national online flight and train ticket booking systems, and banking systems, to small-scale management information systems for enterprises and institutions, as well as home financial management systems. It can also be seen in the increasingly popular dynamic websites on the internet. Therefore, database technology is a fundamental course that computer science professionals must master. This book provides a detailed introduction to the basic principles of databases, but avoids excessive focus on highly theoretical topics. It combines theory with practical application by integrating current popular software. The book is divided into two parts: The first part systematically introduces the basic principles of database systems, as well as the mathematical foundations upon which relational databases are based. It also provides a detailed explanation of the methods for designing relational databases and the standard database query language SQL. The second part introduces the use of the currently popular SQL Server 2000 database management system and the Transact-SQL language used in SQL Server 2000. It also covers database security and, finally, demonstrates how to design a database by integrating an actual application system. This book can serve as a professional textbook for non-computer science majors at ordinary universities or adult education institutions, as well as a reference book or training manual for technical personnel in related fields.