Database Systems An Application-Oriented Approach, Introductory Version

ISBN-10: 0321228383
ISBN-13: 9780321228383
Edition: 2nd 2005 (Revised)
List price: $173.40
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: This book presents the conceptual principles underlying the design and implementation of databases and their applications by providing a solid foundation of the theory underlying database systems.This book takes an applications-oriented approach to  More...

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $173.40
Edition: 2nd
Copyright year: 2005
Publisher: Addison Wesley
Publication date: 3/30/2004
Binding: Paperback
Pages: 688
Size: 7.75" wide x 9.50" long x 1.00" tall
Weight: 2.970
Language: English

This book presents the conceptual principles underlying the design and implementation of databases and their applications by providing a solid foundation of the theory underlying database systems.This book takes an applications-oriented approach to database concepts and covers topics including; ER Modeling, UML, XML, object-oriented databases, SQL, database tuning, and the important software issues that arise when implementing database applications.This book is appropriate for programmers who want to understand database system concepts and how they apply to real-world databases.

(Each Chapter, excluding chaper 1, concludes with Bibliographic Notes and Exercises.)
Preface
Introduction
Overview of Databases and Transactions
What Are Databases and Transactions? Features of Modern Database and Transaction Processing Systems
Major Players in the Implementation and Support of Database and Transaction Processing Systems
Decision Support Systems OLAP and OLTP
The Big Picture
Case Study: A Student Registration System
Introduction to Relational Databases
What Makes a Program a Transaction The Acid Properties
Database Management
The Relational Data Model
What is a Data Model?
The Relational Model
SQL Data Definition Sublanguage
Conceptual Modeling of Databses with Entity-Relationship Diagrams and the Unified Modeling Language
Conceptual Modeling with the E-R Approach
Entities and Entity Types
Relationships and Relationship Types
Advanced Features in Conceptual Data Modeling
From E-R Diagrams to Relational Database Schemas
UML: A New Kid on the Block
A Brokerage Firm Example
Case Study: A Database Design for the Student Registration System
Limitations of Data Modeling Methodologies
Relational Algebra and SQL
Relational Algebra: Under the Hood of SQL
The Query Sublanguage of SQL
Modifying Relation Instances in SQL
Database Design with The Relational Normalization Theory
The Problem of Redundancy
Decompositions
Functional Dependencies
Properties of Functional Dependencies
Normal Forms
Properties of Decompositions
An Algorithm for BCNF Decomposition
Synthesis of 3NF Schemas
The Fourth Normal Form
Advanced 4NF Design
Summary of Normal Form Decomposition
Case Study: Schema Refinement for the Student Registration System
Tuning Issues: To Decompose or Not to Decompose?
Triggers and Active Databases
What Is a Trigger? Semantic Issues in Trigger Handling
Triggers in SQL:1999
Avoiding a Chain Reaction
Using SQL in an Application
What are the Issues Involved?
Embedded SQL
More on Integrity Constraints
Dynamic SQL
JDBC and SQLJ
ODBC
Comparison
Optimizing Dbms Performance and Transaction Processing
Physical Data Organization and Indexing
Disk Organization
Heap Files
Sorted Files
Indices
Multilevel Indexing
Hash Indexing
Special-Purpose Indices
Tuning Issues: Choosing Indices for an Application
The Basics of Query Processing
External Sorting
Computing Projection, Union, and Set Difference
Computing Selection
Computing Joins
Multi-Relational Joins
Computing Aggregate Functions
An Overview of Query Optimization
Overview of Query Processing
Heuristic Optimization Based on Algebraic Equivalences
Estimating the Cost of a Query Execution Plan
Estimating the Size of the Output
Choosing a Plan
Database Tuning
Disk Caches
Tuning the Schema
Tuning the Data Manipulation Language
Tools
Managing Physical Resources
In

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×