A First Course in Database Systems: United States Edition
Edition 2 ed
Publication Date 1 Jan 2002
OverviewWritten by computer scientists, this accessible introduction to database systems focuses on database design and use. The authors provide in-depth coverage of databases from the point of view of the database designer, user, and application programmer, leaving implementation for later courses. It covers the database standards: SQL 1999; SQL/PSM; SQL/CLI; JDBC; ODL; and XML. Among the coverage of SQL is a detailed look at object-relational systems and many aspects of the new SQL 1999 standard. The guide also incorporates: separate discussions of object-oriented design and E/R design; expanded discussions of the object-relational model; the new SQL-99 standard for O-R features; discussion of the technologies used to connect database programming with C or Java code; discussions of SQL/PSM, SQL/CLI, and JDBC; while giving students practical advice on integrating state-of-the-art technologies with databases. The text covers advanced issues important to database designers and users, includes discussions of views, integrity constraints, assertions, triggers, transactions, authorization, and recursion in SQL: 1999. It contains a discussion of how to successfully plan a database application before building it, reflects how these plans are developed in the real world. In almost every section, it provides students with the opportunity to practice and apply the concepts learned in each chapter.