Principles of Database Systems with Internet and Java Applications

Principles of Database Systems with Internet and Java Applications provides a concise and modern treatment of introductory database topics that is suitable for use in undergraduate database courses. It enlists Java and the Internet to add an applications perspective to the core DBMS theory. 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, database systems, Java programming, and the interaction with databases on the World Wide Web. It assumes that readers have a background in programming and helps them to improve their skills in the design and implementation of complex information systems. The coverage of database and information systems material is extensive. Topics include analyzing information requirements, conceptual data modeling, translation of conceptual models to relational models, normalization of relational schemas, SQL, and database applications programming. Interesting examples are used to show students how to apply this material. Additional topics include object-oriented modeling and databases, database performance and optimization, constraints and triggers, transactions, backup and recovery, file structures, indexing, and distributed object technology. 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. 020161247XB04062001