Fundamentals of Database Management Systems

ISBN-10: 0470624701

ISBN-13: 9780470624708

Edition: 2nd 2012

List price: $167.99 Buy it from $84.99
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:

Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics necessary for a deep understanding of the basics. In this issue, there is more emphasis on a practical approach, with new "your turn" boxes and much more coverage in a separate supplement on how to implement databases with Access. In every chapter, the author covers concepts first, then show how they're implemented in continuing case(s.) "Your Turn" boxes appear several times throughout the chapter to apply concepts to projects. And "Concepts in Action" boxes contain examples of concepts used in practice. This pedagogy is easily demonstrable and the text also includes more hands-on exercises and projects and a standard diagramming style for the data modeling diagrams. Furthermore, revised and updated content and organization includes more coverage on database control issues, earlier coverage of SQL, and new coverage on data quality issues.
Used Starting from $97.53
New Starting from $144.29
eBooks Starting from $48.00
Rent eBooks
Buy eBooks
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
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: $167.99
Edition: 2nd
Copyright year: 2012
Publisher: John Wiley & Sons, Limited
Publication date: 10/26/2012
Binding: Hardcover
Pages: 416
Size: 8.00" wide x 9.75" long x 0.75" tall
Weight: 3.190
Language: English

Preface
About the Author
Data: The New Corporate Resource
Introduction
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
Summary
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
Example: The General Hardware Company
Example: Good Reading Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Summary
The Database Management System Concept
Introduction
Data Before Database Management
Records and Files
Basic Concepts in Storing and Retrieving Data
The Database Concept
Data as a Manageable Resource
Data Integration and Data Redundancy
Multiple Relationships
Data Control Issues
Data Independence
DBMS Approaches
Summary
Relational Data Retrieval: Sql
Introduction
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 Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Relational Query Optimizer
Relational DBMS Performance
Relational Query Optimizer Concepts
Summary
The Relational Database Model:
Introduction
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 Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Summary
The Relational Database Model: Additional Concepts
Introduction
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
Summary
Logical Database Design
Introduction
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 Co. 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
Example: General Hardware Co
Example: Good Reading Bookstores
Example: World Music Association
Example: Lucky Rent-A-Car
Testing Tables Converted from E-R Diagrams with Data Normalization
Building the Data Structure with SQL
Manipulating the Data with SQL
Summary
Physical Database Design
Introduction
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
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
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 Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Summary
Object-Oriented Database Management
Introduction
Terminology
Complex Relationships
Generalization
Inheritance of Attributes
Operations, Inheritance of Operations, and Polymorphism
Aggregation
The General Hardware Co. Class Diagram
The Good Reading Bookstores Class Diagram
The World Music Association Class Diagram
The Lucky Rent-A-Vehicle Class Diagram
Encapsulation
Abstract Data Types
Object/Relational Database
Summary
Data Administration, Database Administration, And Data Dictionaries
Introduction
The Advantages of Data and Database Administration
Data as a Shared Corporate Resource
Efficiency in Job Specialization
Operational Management of Data
Managing Externally Acquired Databases
Managing Data in the Decentralized Environment
The Responsibilities of Data Administration
Data Coordination
Data Planning
Data Standards
Liaison to Systems Analysts and Programmers
Training
Arbitration of Disputes and Usage Authorization
Documentation and Publicity
Data's Competitive Advantage
The Responsibilities of Database Administration
DBMS Performance Monitoring
DBMS Troubleshooting
DBMS Usage and Security Monitoring
Data Dictionary Operations
DBMS Data and Software Maintenance
Database Design
Data Dictionaries
Introduction
A Simple Example of Metadata
Passive and Active Data Dictionaries
Relational DBMS Catalogs
Data Repositories
Summary
Database Control Issues: Security, Backup And Recovery, Concurrency
Introduction
Data Security
The Importance of Data Security
Types of Data Security Breaches
Methods of Breaching Data Security
Types of Data Security Measures
Backup and Recovery
The Importance of Backup and Recovery
Backup Copies and Journals
Forward Recovery
Backward Recovery
Duplicate or ''Mirrored'' Databases
Disaster Recovery
Concurrency Control
The Importance of Concurrency Control
The Lost Update Problem
Locks and Deadlock
Versioning
Summary
Client/Server Database And Distributed Database
Introduction
Client/Server Databases
Distributed Database
The Distributed Database Concept
Concurrency Control in Distributed Databases
Distributed Joins
Partitioning or Fragmentation
Distributed Directory Management
Distributed DBMSs: Advantages and Disadvantages
Summary
The Data Warehouse
Introduction
The Data Warehouse Concept
The Data is Subject Oriented
The Data is Integrated
The Data is Non-Volatile
The Data is Time Variant
The Data Must Be High Quality
The Data May Be Aggregated
The Data is Often Denormalized
The Data is Not Necessarily Absolutely Current
Types of Data Warehouses
The Enterprise Data Warehouse (EDW)
The Data Mart (DM)
Which to Choose: The EDW, the DM, or Both?
Designing a Data Warehouse
Introduction
General Hardware Co. Data Warehouse
Good Reading Bookstores Data Warehouse
Lucky Rent-A-Car Data Warehouse
What About a World Music Association Data Warehouse?
Building a Data Warehouse
Introduction
Data Extraction
Data Cleaning
Data Transformation
Data Loading
Using a Data Warehouse
On-Line Analytic Processing
Data Mining
Administering a Data Warehouse
Challenges in Data Warehousing
Summary
Databases And The Internet
Introduction
Database Connectivity Issues
Expanded Set of Data Types
Database Control Issues
Performance
Availability
Scalability
Security and Privacy
Data Extraction into XML
Summary
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.

×