Database Processing : Fundamentals, Design, and Implementation

by Kroenke, David M.; Auer, David

• ISBN13: 9780131672673
• ISBN10: 0131672673
• Edition: 10th
• Format: Hardcover
• Copyright: 2010-01-01
• Publisher: Pearson College Div

Summary

Revised to reflect the needs of todayrs"s users, this 10 th edition ofDatabase Processingassures 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 resultsseeing 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.

Table of Contents

Getting started	p. 1
Introduction	p. 3
Introduction to structured query language	p. 27
Database design	p. 67
The relational model and normalization	p. 69
Database design using normalization	p. 101
Data modeling with the entity-relationship model	p. 119
Transforming data models into database designs	p. 171
Database implementation	p. 217
SQL for database construction and application processing	p. 219
Database redesign	p. 265
Multiuser database processing	p. 291
Managing multiuser databases	p. 293
Managing databases with Oracle	p. 325
Managing databases with SQL Server 2000	p. 371
Database access standards	p. 409
ODBC, OLE DB, ADO, and ASP	p. 411
XML and ADO.NET	p. 449
JDBC, Java server pages, and MySQL	p. 497
Conclusion	p. 531
Database processing for business intelligence systems	p. 529
Introduction to Microsoft Access	p. 561
The IDEF1X standard	p. 575
UML-style entity-relationship diagrams	p. 583
Data structures for database processing	p. 589
The semantic object model	p. 609
Table of Contents provided by Blackwell. All Rights Reserved.