x

Our Privacy Policy has changed. By using this site, you agree to the Privacy Policy.

Database Design and Implementation

ISBN-10: 0471757160
ISBN-13: 9780471757160
Edition: 2009
Authors: Edward Sciore
List price: $195.95 Buy it from $62.57
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: While it's important to know how to write queries, it is equally important to know how they are processed. Sciore covers the traditional database system concepts from a systems perspective. This perspective allows software developers to investigate  More...

Used Starting from $120.53
New Starting from $164.33
eBooks Starting from $53.63
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
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: $195.95
Copyright year: 2009
Publisher: John Wiley & Sons, Incorporated
Publication date: 10/24/2008
Binding: Hardcover
Pages: 784
Size: 7.75" wide x 9.25" long x 1.25" tall
Weight: 2.750
Language: English

While it's important to know how to write queries, it is equally important to know how they are processed. Sciore covers the traditional database system concepts from a systems perspective. This perspective allows software developers to investigate why database systems are the way they are. The book includes a simple but fully-functional database system, called SimpleDB that allows readers to examine the code and modify it. The end of each chapter contains suggested readings that provide references to relevant Web pages, research articles, reference manuals, and books. Software developers will be able to apply the information to build an application that uses a database system.

Introduction: Why a Database System?
Databases and Database Systems
Record Storage
Multi-User Access
Memory Management
Data Models and Schemas
Physical Data Independence
Logical Data Independence
Chapter Summary
Suggested Reading
Exercises
Rational Databases
Data Definition
Tables
Null Values
Keys
Foreign Keys and Referential Integrity
Integrity Constraints
Specifying Tables in SQL
Chapter Summary
Suggested Reading
Exercises
Data Design
Designing Tables id Difficult
Class Diagrams
Transforming Class Diagrams to Tables
The Design Process
Relationships to Constraints
Functional Dependancies and Normalization
Chapter Summary
Suggested Reading
Exercises
Data Manipulation
Queries
Relational Algebra
SQL Queries
SQL Updates
Views
Chapter Summary
Suggested Reading
Exercises
Integrity and Security
The Need for Integrity and Security
Assertions
Triggers
Authorization
Mandatory Access Control
Chapter Summary
Suggested Reading
Exercises
Improving Query Efficiency
The Virtues of Controlled Redundancy
Materialized Views
Indexes
Chapter Summary
Suggested Reading
Exercises
Client-Server Database Systems
Clients and Servers
The Data-Sharing Problem
Database Clients and Servers
The Derby and SimpleDB Database Servers
Running Database Clients
The Derby ij Client
The SimpleDB Version of SQL
Chapter Summary
Suggested Reading
Exercises
Using JDBC
Basic JDBC
Advanced JDBC
Computing in Java vs. SQL
Chapter Summary
Suggested Reading
Exercises
Persistent Java Objects
The Domain Model and View of a Client Program
The Problem with Our Domain Model
The Java Persistence Architecture
The Java Persistence Query Language
Downloading a JPA Implementation
Chapter Summary
Suggested Reading
Exercises
Data Exchange
Sharing Database Data with Non-Users
Saving Data in an XML Document
Restructuring an XML Document
Generating XML Data from the Database
Chapter Summary
Suggested Reading
Exercises
Webserver-Based Database Clients
Types of Database Clients
Interacting with a Web Server
Basic Servlet Programming
Managing Database Connections
Configuring a Servlet Container
Chapter Summ

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

×