Revised to reflect the needs of today’s users, this 10^th edition of Database Processing assures that you will learn marketable skills. By presenting SQL SELECT statements near the beginning of the book readers will know early on how to query data and obtain results–seeing firsthand some of the ways that database technology is useful in the marketplace. By utilizing free software downloads, you will be able to actively use a DBMS product by the end of the 2^nd chapter.   Each topic appears in the context of accomplishing practical tasks. Its spiral approach to database design (incorporating all 3 sources: from the integration of existing data, from new information, and the need to redesign an existing database) provides users with enhanced information not available in other database books on the market. Topics include: SQL, database design, implementation, processing, access standards, and business intelligence. An excellent reference and handbook for information systems professionals such as database administrators, database designers, systems analysts, web-database developers, and programmers of database applications.

1. Introduction.

2. Introduction to Structured Query Language (SQL).

PART II. DATABASE DESIGN.

3. The Relational Model and Normalization.

4. Database Design Using Normalization.

5. Data Modelig with the Entity-Relationship Model.

6. Transforming Data Models into Database Designs.

PART III. DATABASE IMPLEMENTATION.    

7. SQL for Database Construction and Application Processing.

8. Database Redesign.

PART IV. MULTI-USER DATABASE PROCESSING.

9. Managing Multi-User Databases.

10. Managing Databases with Oracle.

11. Managing databases with SQL Server 2000.

PART V. DATABASE ACCESS STANDARDS.

12. ODBC, OLE DB, ADO, and ASP.

13. XML and ADO.NET.

14. JDBC, Java Server Pages, and MySQL.

PART VI. BUSINESS INTELLIGENCE.

15. Database Processing for Business Intelligence Systems.

Appendix A. Microsoft Access.

Appendix B. The IDEF1X Standard.

Appendix C. The UML Data Model.

Appendix D. The Semantic Object Data Model.

Appendix E. Data Structures for Databse Processing.

Glossary.

Bibliography.

Index.