Modern Database Management

ISBN-10: 0132212110

ISBN-13: 9780132212113

Edition: 8th 2007 (Revised)

Authors: Jeffrey A. Hoffer, Mary B. Prescott, Fred R. McFadden

List price: $166.67
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:

Reacting to the business environment, this work addresses issues such as Internet, data warehousing and object-orientation. The text instructs from a business perspective, allowing students to understand database management within a business.
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: $166.67
Edition: 8th
Copyright year: 2007
Publisher: Prentice Hall PTR
Binding: Hardcover
Pages: 656
Size: 8.50" wide x 10.75" long x 1.25" tall
Weight: 3.432
Language: English

Preface
The Context of Database Management
Part I Overview
The Database Environment
Learning Objectives
Data Matters!
Introduction
Basic Concepts and Definitions
Traditional File Processing Systems
File Processing Systems at Pine Valley Furniture Company
The Database Approach
Advantages of The Database Approach
Cautions About Database Benefits
Costs and Risks of The Database Approach
Components of the Database Environment
The Range of Database Applications
Evolution of Database Systems
Summary
Chapter Review
Case: Mountain View Community Hospital
The Database Development Process
Learning Objectives
Introduction
Database Development Within Information Systems Development
Database Development Process
Managing the People Involved in Database Development
Three-Schema Architecture for Database Development
Three-Tiered Database Location Architecture
Developing a Database Application for Pine Valley Furniture Company
Summary
Chapter Review
Case: Mountain View Community Hospital
Database Analysis
Part II Overview
Modeling Data in the Organization
Learning Objectives
Introduction
Modeling the Rules of the Organization
The E-R Model: An Overview
Modeling Entities and Attributes
Modeling Relationships
E-R Modeling Example: Pine Valley Furniture Company
Database Processing at Pine Valley Furniture
Summary
Chapter Review
Case: Mountain View Community Hospital
The Enhanced E-R Model and Business Rules
Learning Objectives
Introduction
Representing Supertypes and Subtypes
Specifying Constraints in Supertype/Subtype Relationships
EER Modeling Example: Pine Valley Furniture
Entity Clustering
Packaged Data Models
Business Rules Revisited
Summary
Chapter Review
Case: Mountain View Community Hospital
Database Design
Part III Overview
Logical Database Design and the Relational Model
Learning Objectives
Introduction
The Relational Data Model
Integrity Constraints
Transforming EER Diagrams into Relations
Introduction to Normalization
Normalization Example: Pine Valley Furniture Company
Merging Relations
A Final Step for Defining Relational Keys
Summary
Chapter Review
Case: Mountain View Community Hospital
Physical Database Design and Performance
Learning Objectives
Introduction
Physical Database Design Process
Designing Fields
Designing Physical Records and Denormalization
Designing Physical Files
Using and Selecting Indexes
RAID: Improving File Access Performance by Parallel Processing
Designing Databases
Optimizing for Query Performance
Summary
Chapter Review
Case: Mountain View Community Hospital
Implementation
Part IV Overview
Introduction to SQL
Learning Objectives
Introduction
History of the SQL Standard
The Role of SQL in a Database Architecture
The SQL Environment
Defining a Database in SQL
Inserting, Updating, and Deleting Data
Internal Schema Definition in RDBMSs
Processing Single Tables
Summary
Chapter Review
Case: Mountain View Community Hospital
Advanced SQL
Learning Objectives
Introduction
Processing Multiple Tables
Ensuring Transaction Integrity
Data Dictionary Facilities
SQL:2003 Enhancements and Extensions to SQL
Triggers and Routines
Embedded SQL and Dynamic SQL
Summary
Chapter Review
Case: Mountain View Community Hospital
The Client/Server Database Environment
Learning Objectives
Location, Location, Location!
Introduction
Client/Server Architectures
Three-Tier Architectures
Partitioning an Application
Role of the Mainframe
Using Middleware
Client/Server Issues
Using ODBC to Link External Tables Stored on a Database Server
Using JDBC to Link External Tables Stored on a Database Server
Looking Forward with Client/Server in Mind
Summary
Chapter Review
Case: Mountain View Community Hospital
The Internet Database Environment
Learning Objectives
Introduction
The Internet and Database Connection
The Internet Environment
Common Internet Architecture Components
Web-to-Database Tools
Summary
Chapter Review
Case: Mountain View Community Hospital
Data Warehousing
Learning Objectives
Introduction
Basic Concepts of Data Warehousing
Data Warehouse Architectures
Some Characteristics of Data Warehouse Data
The Reconciled Data Layer
Data Transformation
The Derived Data Layer
The User Interface
Summary
Chapter Review
Case: Mountain View Community Hospital
Advanced Database Topics
Part V Overview
Data and Database Administration
Learning Objectives
Introduction
The Roles of Data and Database Administrators
The Open-Source Movement
Modeling Enterprise Data
Managing Data Security
Database Backup and Recovery
Controlling Concurrent Access
Managing Data Quality
Data Dictionaries and Repositories
Overview of Tuning the Database for Performance
Data Availability
Summary
Chapter Review
Case: Mountain View Community Hospital
Overview: Distributed Databases
Learning Objectives
Overview
Chapter Review
Overview: Object-Oriented Data Modeling
Learning Objectives
Overview
Chapter Review
Overview: Object-Oriented Database Development
Learning Objectives
Overview
Chapter Review
Data Modeling Tools and Notation
Comparing E-R Modeling Conventions
Visio Professional 2003 Notation
AllFusion ERwin Data Modeler 4.1 SPI Notation
Sybase Power Designer 11.1 Notation
Oracle Designer Notation
Comparison of Tool Interfaces and E-R Diagrams
Advanced Normal Forms
Boyce-Codd Normal Form
Anomalies in STUDENT_ADVISOR
Definition of Boyce-Codd Normal Form (BCNF)
Converting a Relation to BCNF
Fourth Normal Form
Multivalued Dependencies
Higher Normal Forms
Appendix Review
Key Terms
References
Web Resources
Data Structures
Pointers
Data Structure Building Blocks
Linear Data Structures
Stacks
Queues
Sorted Lists
Multilists
Hazards of Chain Structures
Trees
Balanced Trees
References
Object-Relational Databases
Basic Concepts and Definitions
Features of an ORDBMS
Complex Data Types
Enhanced SQL
A Simple Example
Content Addressing
Advantages of the Object-Relational Approach
ORDBMS Vendors and Products
Appendix Review
Key Terms
References
Web Resources
Glossary of Acronyms
Glossary of Terms
Index
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.

×