Database Systems The Complete Book

ISBN-10: 0131873253

ISBN-13: 9780131873254

Edition: 2nd 2009

List price: $214.80 Buy it from $21.00 Rent it from $33.24
eBook available
This item qualifies for FREE shipping

*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.

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 introduction to database systems offers a comprehensive approach, focusing on database design, database use, and implementation of database applications and database management systems.KEY TOPICS: The first half of the book provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. It covers the latest database standards SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other texts. The second half of the book covers databases from the point of view of the DBMS implementor, focusing on storage structures, query processing, and transaction management. The book covers the main techniques in these areas with broader coverage of query optimization than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques. Ideal for professionals and students interested in database systems. A basic understanding of algebraic expressions and laws, logic, basic data structure, OOP concepts, and programming environments is implied.

Used Starting from $93.82
New Starting from $216.30
Rent Starting from $33.24
eBooks Starting from $42.99
Rent
Buy
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
Calculus 1 Online content $4.95 $1.99
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

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $214.80
Edition: 2nd
Copyright year: 2009
Publisher: Prentice Hall PTR
Publication date: 6/5/2008
Binding: Hardcover
Pages: 1248
Size: 7.25" wide x 9.25" long x 1.75" tall
Weight: 4.422
Language: English

The Worlds of Database Systems
The Evolution of Database Systems
Early Database Management Systems
Relational Database Systems
Smaller and Smaller Systems
Bigger and Bigger Systems
Information Integration1.2 Overview of a Database Management System
Data-Definition Language Commands
Overview of Query Processing
Storage and Buffer Management
Transaction Processing
The Query Processor1.3 Outline of Database-System Studies1.4 References for Chapter 1I Relational Database Modeling2 The Relational Model of Data2.1 An Overview of Data Models
What is a Data Model?
Important Data Models
The Relational Model in Brief
The Semistructured Model in Brief
Other Data Models
Comparison of Modeling Approaches2.2 Basics of the Relational Model
Attributes
Schemas
Tuples
Domains2 CONTENTS
Equivalent Representations of a Relation
Relation Instances
Keys of Relations
An Example Database Schema
Exercises for Section
De ning a Relation Schema in SQL
Relations in SQL
Data Types
Simple Table Declarations
Modifying Relation Schemas
Default Values
Declaring Keys
Exercises for Section
An Algebraic Query Language
Why Do We Need a Special Query Language?
What is an Algebra?
Overview of Relational Algebra
Set Operations on Relations
Projection
Selection
Cartesian Product
Natural Joins
Theta-Joins
Combining Operations to Form Queries
Naming and Renaming
Relationships Among Operations
A Linear Notation for Algebraic Expressions
Exercises for Section
Constraints on Relations
Relational Algebra as a Constraint Language
Referential Integrity Constraints
Key Constraints
Additional Constraint Examples
Exercises for Section
Summary of Chapter 22.7 References for Chapter
Design Theory for Relational Databases3.1 Functional Dependencies
De nition of Functional Dependency
Keys of Relations
Superkeys
Exercises for Section
Rules About Functional Dependencies
Reasoning About Functional Dependencies
The Splitting/Combining Rule
Trivial Functional Dependencies
Computing the Closure of Attributes
Why the Closure Algorithm Works
The Transitive Rule
Closing Sets of Functional Dependencies
Projecting Functional Dependencies
Exercises for Section
Design of Relational Database Schemas
Anomalies
Decomposing Relations
Boyce-Codd Normal Form
Decomposition into BCNF
Exercises for Section
Decomposition: The Good, Bad, and Ugly
Recovering Information from a Decomposition
The Chase Test for Lossless Join
Why the Chase Works
Dependency Preservation
Exercises for Section
Third Normal Form
Definition of Third Normal Form
The Synthesis Algorithm for 3NF Schemas
Why the 3NF Synthesis Algorithm Works
Exercises for Section
Multivalued Dependencies
Attribute Independence and Its ConsequentRedundancy
Definition of Multivalued Dependencies
Reas
×
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.

×