Principles of Database Systems With Internet and Java Applications

Description

This book provides a concise and modern treatment of introductory database topics that enlists Java and the Internet to present core Database Management (DBMS) theory from an applications perspective. It incorporates programming and database applications when presenting the core theory behind DBMS and their applications.

Information management is the central theme of Principles of Database Systems with Internet and Java Applications. The book motivates the development of data models and the representation of information in relational database systems. Students learn how to define database content with Entity-Relationship models, and how to represent that content in relational systems. They become thoroughly familiar with the SQL language, and learn exactly what is required to build quality information-rich applications. Students also learn how the World Wide Web and Java can work together to publish and collect information in the widest possible context.

This book covers the basic material of information management in detail. Topics covered include analyzing information requirements, conceptual data modeling, translation of conceptual models to relational needs, normalization of relational schemas, SQL, and database application programming. Additional topics include object-oriented modeling and object databases, database performance and optimization, constraints and triggers, transactions, and file structures.

The interaction between applications and databases is discussed and illustrated in the context of Web sites. The JDBC classes of Java provide a database- and platform-independent method of creating database applications, and all of these classes are thoroughly discussed with abundant examples. After learning the fundamentals of HTML and CGI programming, students create their own Web sites using Java programs to service CGI requests and generate HTML responses. Further topics include the use of Java servlets to replace CGI programs and the use of Java I/O classes for the development of file structures.

The Java language provides the foundation for all programming examples because of its portable approach to database access through the JDBC classes. Students do not need extensive experience with Java before using this book, only knowledge of an object-oriented language.

Appropriate Courses

Database Systems.

Features

• Presents the traditional topics covered in a first database course with emphasis on working with DBMS (as opposed to focusing on theoretical concepts behind creating DBMS, and advanced topics).
• Includes a running case study—"Big Hit Video, Inc."—to illustrate the implementation of core concepts in Microsoft Access and SQL by building from simple to complex.
• Introduces Java in an appendix so students can cover the necessary aspects of the language to complete the exercises in the text.
• Provides an actual full DB implementation in Access and in SQL and a sample Web site with all required Java classes.

Table Of Contents

(Most chapters contain "Chapter Summary," "Key Terms," "Exercises," and "Further Readings.")
1. Information Management and Database Systems.