Database Principles and Applications Tutorial - (Second Edition) (Includes CD-ROM)

Author: Huang Decai, Xu Yun, Wang Wenjuan / Country: Mainland China
Publisher:
Publish Date: 2006-07-01
Features: This book provides a detailed introduction to database principles, methods, and their application development technologies. It includes numerous examples and a moderate number of exercises. The accompanying CD-ROM contains all the SQL examples from the book, as well as source programs and installation packages for database application system examples developed using Delphi and Visual Basic. Additionally, a set of PPT lecture slides is included as a gift. This not only facilitates multimedia teaching for instructors but also aids students in self-study. It can serve as a textbook for "Database Principles and Applications" courses in ordinary universities and colleges, a teaching material and reference book for adult education and self-study exams, and a reference for IT professionals.
This book provides a detailed introduction to database principles, methods, and their application development technologies. The book is divided into 8 chapters, covering topics such as the relational database standard language SQL, data models, the schema structure of database systems, relational models and relational algebra operations, normalization theory for relational schemas, database security and protection, RAID technology, database design steps and implementation, the architecture of database application systems, Microsoft SQL Server 2000's security management, integrity policies, recovery techniques, concurrency control methods, triggers, and stored procedures, as well as the development process of a simple C/S-structured database application system based on Delphi 6.0 and SQL Server 2000.
The book also introduces new developments in database technology, such as object-oriented databases, distributed databases, data warehousing, and data mining technologies. It includes numerous examples and a moderate number of exercises. The accompanying CD-ROM contains all the SQL examples from the book, as well as source programs and installation packages for database application system examples developed using Delphi and Visual Basic. Additionally, a set of PPT lecture slides is included as a gift. This not only facilitates multimedia teaching for instructors but also aids students in self-study.