Fundamentals of Database Management Systems

ISBN-10: 0471262978
ISBN-13: 9780471262978
Edition: 2005
List price: $154.95
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: * A compact, practical introduction that concentrates on providing readers with a clear understanding of database fundamentals while providing a broad survey of all the major topics of the field * Written in a clear, friendly style that progresses  More...

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

Get an entry for every item you buy, rent, or sell.

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
Periodic Table 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: $154.95
Copyright year: 2005
Publisher: John Wiley & Sons, Incorporated
Publication date: 3/16/2004
Binding: Hardcover
Pages: 384
Size: 8.00" wide x 10.00" long x 0.75" tall
Weight: 2.288
Language: English

* A compact, practical introduction that concentrates on providing readers with a clear understanding of database fundamentals while providing a broad survey of all the major topics of the field * Written in a clear, friendly style that progresses step-by-step through all of the major database topics * When readers finish the book, they will be able to immediately apply what they've learned * Makes heavy use of examples, including four major examples that are used throughout the text

Preface
About the Author
Data: The New Corporate Resource
The History of Data
The Origins of Data
Data Through the Ages
Early Data Problems Spawn Calculating Devices
Swamped with Data
Modern Data Storage Media
Data in Today''s Information Systems Environment
Using Data for Competitive Advantage
Problems in Storing and Accessing Data
Data as a Corporate Resource
The Database Environment
Simple File Storage and Retrieval
What Is Data?
Important Objects and Facts
Records and Files
Basic Concepts in Storing and Retrieving Data
Retrieving and Manipulating Data
Disk Storage
The Need for Disk Storage
How Disk Storage Works,File Organizations and Access Methods
The Goal: Locating a Record
The Index
Hashed Files
Data Modeling
Introduction
Binary Relationships
What Is a Binary Relationship?
Cardinality
Modality
More About Many-to-Many Relationships
Unary Relationships
One-to-One Unary Relationship
One-to-Many Unary Relationship
Many-to-Many Unary Relationship
Ternary Relationships
Examples
The General Hardware Company
Good Reading Bookstores
World Music Association
Lucky Rent-A-Car
The Database Management System Concept
The Database Concept
Data as a Manageable Resource
Data Integration and Data Redundancy
Multiple Relationships
Data Control Issues
Data Independence
DBMS Approaches
The Relational Database Model: Introduction
The Relational Database Concept
Relational Terminology
Primary and Candidate Keys
Foreign Keys and Binary Relationships
Data Retrieval from a Relational Database
Extracting Data from a Relation
The Relational Select Operator
The Relational Project Operator
Combination of the Relational Select and Project Operators
Extracting Data Across Multiple Relations: Data Integration
Example: Good Reading Bookstores
Example: World Music Association
Example: Lucky Rent-A-Car
The Relational Database Model: Additional Concepts
Relational Structures for Unary and Ternary Relationships
Unary One-to-Many Relationships
Unary Many-to-Many Relationships
Ternary Relationships
Referential Integrity
The Referential Integrity Concept
Three Delete Rules
Logical Database Design
Converting E-R Diagrams into Relational Tables
Introduction
Converting a Simple Entity
Converting Entities in Binary Relationships
Converting Entities in Unary Relationships
Converting Entities in Ternary Relationships
Designing the General Hardware Company Database
Designing the Good Reading Bookstores Database
Designing the World Music Association Database
Designing the Lucky Rent-A-Car Database
The Data Normalization Process
Introduction to the Data Normalization Technique
Steps in the Data Normalization Process
General Hardware Company Example
Good Reading Bookstores Example
World Music Association Example
Lucky Rent-A-Car Example
Testing Tables Converted from E-R Diagrams with Data Normalization
Physical Database Design
Inputs to Physical Database Design
The Tables Produced by the Logical Database Design Process
Business Environment Requirements
Data Characteristics
Application Characteristics
Operational Requirements: Data Security, Backup and Recovery
Hardware and Software Characteristics
Physical Database Design Techniques
Adding External Features
Reorganizing Stored Data
Splitting a Table into Multiple Tables
Changing Attributes in a Table
Adding Attributes to a Table
Combining Tables
Adding New Tables
Example: Good Reading Bookstores
Example: World Music Association
Example: Lucky Rent-A-Car
Relational Data Retrieval: SQL
SQL Commands
Building the Data Structure
Data Manipulation Operations
Data Retrieval with the SQL SELECT Command
Introduction to the SQL SELECT Command
Basic Functions
Built-In Functions
Grouping Rows
The Join
Subqueries
A Strategy for Writing SQL SELECT Commands
Example: Good Reading Bookstores
Example: World Music Association
Example: Lucky Rent-A-Car
Relational Query Optimizer
Relational DBMS Performance
Relational Query Optimizer Concepts
Cha

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

×