[Book Cover]

Database Processing: Fundamentals, Design and Implementation, 7/e

David M. Kroenke

Published July, 1999 by Prentice Hall Business Publishing

Copyright 2000, 601 pp.
Cloth
ISBN 0-13-084816-6


Sign up for future
mailings
on this subject.

See other books about:
    Database Design-Computer Information Systems

    Introduction to Database Management-Computer Information Systems

    Database Management and Design-Computer Science


Summary

For undergraduate courses in Database Design, Introduction to Database Management, and Database Management and Design in departments of Business Computer Information Systems and Computer Science. The text provides a solid foundation in the fundamentals of database processing. It is organized into several parts, beginning with the core components of database processing including building databases and related applications, data modeling, and progresses to the transformation of data models into relational database designs. Relational database implementation is discussed in the ensuing sections. Key technological advances are thoroughly discussed, such as the expanding Internet and organizational intranet technology and its role and function within application publishing. The concluding parts deal with database processing and object-oriented DBMS technology.

Features


NEW—Internet technology—Cutting edge information on the use of Internet technology as a “wrapper” around the base fundamentals of database design. No other text offers such an encompassing and critical discussion of the Internet and organization intranets.

  • Familiarizes the student with the latest technological applications of publishing databases using Internet technology. Ex. Chs. 11, 12, 13
NEW—Examples using Access 2000—The text uses the latest version of Access to illustrate text discussion. Access 2000 is the DBMS which student most likely will have had contact with or will have contact with in both their educational and professional careers.
  • Provides a familiar frame of reference to encourage the student to feel comfortable with the materials.
NEW—SQL Server 7.0 with the text—FREE—An evaluation edition of Microsoft's SQL Server 7.0 is included with the text and can operate on Windows 95, Windows 98, Windows NT, and Windows 2000. Full Software, 120 day license.
  • Provides the student with hands-on experience working with server software.
NEW—Wall Data's DBApp—FREE—This free software is available from the Prentice Hall website (www.prenhall.com/kroenke) —serves a multitude of purposes: creates semantic object data models, generates Access and SQL Server database schemas, and creates .asp pages for publishing database views on the web.
  • Provides students with a valuable opportunity to work with live data.
NEW—Microsoft IIS Active Server Pages—Process tables using Microsoft IIS Active Server Pages that call Active Data Objects from script.
  • Presents clear examples of using SQL select statements to demonstrate the power of Internet technology.
NEW—Discussion of XML as protocol to exchange database views—Provides the rationale for presenting XML as a revolutionary standard for electronic data exchange.
  • Offers an in-depth discussion to introduce students to new applications for database technology.
NEW—Pivot Table Service—Discusses the service as a desktop version of its OLAP server, including a substantial discussion of local OLAP cubes and those stored on remote servers, Provides information on data warehousing as well.
  • Helps students become aware of the important new developments with regard to OLAP servers.
New discussion of the role of database applications—Shows the use of multiple SQL statements to create, read, update, and delete data view instances.
  • Illustrates the relevance of SQL to database application processing.


Table of Contents
I. INTRODUCTION.
    1. Introduction to Database Processing.
    2. Introduction to Database Development.

II. DATA MODELING.
    3. The Entity-Relationship Model.
    4. The Semantic Object Model.
III. DATABASE AND DATABASE APPLICATION DESIGN.
    5. The Relational Model and Normalizaton.
    6. Database Design Using Entity-Relationship Models.
    7. Database Design with Semantic Object Models.
IV. DATABASE IMPLEMENTATION WITH THE RELATIONAL MODEL.
    8. Foundations of Relational Implementation.
    9. Structured Query Language.
    10. Database Application Design.
V. USING INTERNET TECHNOLOGY.
    11. Database Applications Using Internet Technology.
    12. Managing Multi-User Databases.
    13. Accessing the Database Server: ODBC, OLE DB, and ADO.
VI. ENTERPRISE DATABASES.
    14. Sharing Enterprise Data.
    15. Relational Implementation with DB2.
    16. The Hierarchical and Network Data Models.
VII. OBJECT-ORIENTED DATABASE PROCESSING.
    17. Object-Oriented Database Processing.
APPENDICES.
    A. Data Structures for Database Processing.
    B. Using SQL Server 7.0
    C. Working with Cyberprise DBApp.
    Glossary.
    Bibliography.
    Index.


[Help]

© Prentice-Hall, Inc. A Simon & Schuster Company
Comments To webmaster@prenhall.com