Skip Navigation
List Price: $233.77

Buy Used

In Stock. Usually ships in 24 hours.

Rent Textbook

Select for Price
Add to Cart Free Shipping
There was a problem. Please try again later.

New Textbook

We're Sorry
Sold Out

Fundamentals of Database Management Systems, 2nd Edition,9780470624708

Fundamentals of Database Management Systems, 2nd Edition

Edition: 2nd
Format: Paperback
Pub. Date: 10/1/2011
Publisher(s): Wiley

Customer Reviews

select 'this book'  February 4, 2015
Rating StarRating StarRating StarRating StarRating Star

if you're taking an introduction to databases class. It has plenty of examples and explains concepts well through the first few chapters that we've covered in class.

Fundamentals of Database Management Systems, 2nd Edition: 5 out of 5 stars based on 1 user reviews.


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.

Table of Contents

Prefacep. xiii
About the Authorp. xvii
Data: The New Corporate Resourcep. 1
Introductionp. 2
The History of Datap. 2
The Origins of Datap. 2
Data Through the Agesp. 5
Early Data Problems Spawn Calculating Devicesp. 7
Swamped with Datap. 8
Modern Data Storage Mediap. 9
Data in Today's Information Systems Environmentp. 12
Using Data for Competitive Advantagep. 12
Problems in Storing and Accessing Datap. 12
Data as a Corporate Resourcep. 13
The Database Environmentp. 14
Summaryp. 15
Data Modelingp. 19
Introductionp. 20
Binary Relationshipsp. 20
What is a Binary Relationship?p. 20
Cardinalityp. 23
Modalityp. 24
More About Many-to-Many Relationshipsp. 25
Unary Relationshipsp. 28
One-to-One Unary Relationshipp. 28
One-to-Many Unary Relationshipp. 29
Many-to-Many Unary Relationshipp. 29
Ternary Relationshipsp. 31
Example: The General Hardware Companyp. 31
Example: Good Reading Book Storesp. 34
Example: World Music Associationp. 35
Example: Lucky Rent-A-Carp. 36
Summaryp. 37
The Database Management System Conceptp. 41
Introductionp. 42
Data Before Database Managementp. 43
Records and Filesp. 43
Basic Concepts in Storing and Retrieving Datap. 46
The Database Conceptp. 48
Data as a Manageable Resourcep. 48
Data Integration and Data Redundancyp. 49
Multiple Relationshipsp. 56
Data Control Issuesp. 58
Data Independencep. 60
DBMS Approachesp. 60
Summaryp. 63
Relational Data Retrieval: Sqlp. 67
Introductionp. 68
Data Retrieval with the SQL SELECT Commandp. 68
Introduction to the SQL SELECT Commandp. 68
Basic Functionsp. 70
Built-In Functionsp. 81
Grouping Rowsp. 83
The Joinp. 85
Subqueriesp. 86
A Strategy for Writing SQL SELECT Commandsp. 89
Example: Good Reading Book Storesp. 90
Example: World Music Associationp. 92
Example: Lucky Rent-A-Carp. 95
Relational Query Optimizerp. 97
Relational DBMS Performancep. 97
Relational Query Optimizer Conceptsp. 97
Summaryp. 99
The Relational Database Model:
Introductionp. 105
Introductionp. 106
The Relational Database Conceptp. 106
Relational Terminologyp. 106
Primary and Candidate Keysp. 109
Foreign Keys and Binary Relationshipsp. 111
Data Retrieval from a Relational Databasep. 124
Extracting Data from a Relationp. 124
The Relational Select Operatorp. 125
The Relational Project Operatorp. 125
Combination of the Relational Select and Project Operatorsp. 126
Extracting Data Across Multiple Relations: Data Integrationp. 127
Example: Good Reading Book Storesp. 129
Example: World Music Associationp. 130
Example: Lucky Rent-A-Carp. 132
Summaryp. 132
The Relational Database Model: Additional Conceptsp. 137
Introductionp. 138
Relational Structures for Unary and Ternary Relationshipsp. 139
Unary One-to-Many Relationshipsp. 139
Unary Many-to-Many Relationshipsp. 143
Ternary Relationshipsp. 146
Referential Integrityp. 150
The Referential Integrity Conceptp. 150
Three Delete Rulesp. 152
Summaryp. 153
Logical Database Designp. 157
Introductionp. 158
Converting E-R Diagrams into Relational Tablesp. 158
Introductionp. 158
Converting a Simple Entityp. 158
Converting Entities in Binary Relationshipsp. 160
Converting Entities in Unary Relationshipsp. 164
Converting Entities in Ternary Relationshipsp. 166
Designing the General Hardware Co. Databasep. 166
Designing the Good Reading Bookstores Databasep. 170
Designing the World Music Association Databasep. 171
Designing the Lucky Rent-A-Car Databasep. 173
The Data Normalization Processp. 174
Introduction to the Data Normalization Techniquep. 175
Steps in the Data Normalization Processp. 177
Example: General Hardware Cop. 185
Example: Good Reading Bookstoresp. 186
Example: World Music Associationp. 188
Example: Lucky Rent-A-Carp. 188
Testing Tables Converted from E-R Diagrams with Data Normalizationp. 189
Building the Data Structure with SQLp. 191
Manipulating the Data with SQLp. 192
Summaryp. 193
Physical Database Designp. 199
Introductionp. 200
Disk Storagep. 202
The Need for Disk Storagep. 202
How Disk Storage Worksp. 203
File Organizations and Access Methodsp. 207
The Goal: Locating a Recordp. 207
The Indexp. 207
Hashed Filesp. 215
Inputs to Physical Database Designp. 218
The Tables Produced by the Logical Database Design Processp. 219
Business Environment Requirementsp. 219
Data Characteristicsp. 219
Application Characteristicsp. 220
Operational Requirements: Data Security, Backup, and Recoveryp. 220
Physical Database Design Techniquesp. 221
Adding External Featuresp. 221
Reorganizing Stored Datap. 224
Splitting a Table into Multiple Tablesp. 226
Changing Attributes in a Tablep. 227
Adding Attributes to a Tablep. 228
Combining Tablesp. 230
Adding New Tablesp. 232
Example: Good Reading Book Storesp. 233
Example: World Music Associationp. 234
Example: Lucky Rent-A-Carp. 235
Summaryp. 237
Object-Oriented Database Managementp. 247
Introductionp. 248
Terminologyp. 250
Complex Relationshipsp. 251
Generalizationp. 251
Inheritance of Attributesp. 253
Operations, Inheritance of Operations, and Polymorphismp. 254
Aggregationp. 255
The General Hardware Co. Class Diagramp. 256
The Good Reading Bookstores Class Diagramp. 256
The World Music Association Class Diagramp. 259
The Lucky Rent-A-Vehicle Class Diagramp. 260
Encapsulationp. 260
Abstract Data Typesp. 262
Object/Relational Databasep. 263
Summaryp. 264
Data Administration, Database Administration, And Data Dictionariesp. 269
Introductionp. 270
The Advantages of Data and Database Administrationp. 271
Data as a Shared Corporate Resourcep. 271
Efficiency in Job Specializationp. 272
Operational Management of Datap. 273
Managing Externally Acquired Databasesp. 273
Managing Data in the Decentralized Environmentp. 274
The Responsibilities of Data Administrationp. 274
Data Coordinationp. 274
Data Planningp. 275
Data Standardsp. 275
Liaison to Systems Analysts and Programmersp. 276
Trainingp. 276
Arbitration of Disputes and Usage Authorizationp. 277
Documentation and Publicityp. 277
Data's Competitive Advantagep. 277
The Responsibilities of Database Administrationp. 278
DBMS Performance Monitoringp. 278
DBMS Troubleshootingp. 278
DBMS Usage and Security Monitoringp. 279
Data Dictionary Operationsp. 279
DBMS Data and Software Maintenancep. 280
Database Designp. 280
Data Dictionariesp. 281
Introductionp. 281
A Simple Example of Metadatap. 282
Passive and Active Data Dictionariesp. 284
Relational DBMS Catalogsp. 287
Data Repositoriesp. 287
Summaryp. 287
Database Control Issues: Security, Backup And Recovery, Concurrencyp. 291
Introductionp. 292
Data Securityp. 293
The Importance of Data Securityp. 293
Types of Data Security Breachesp. 294
Methods of Breaching Data Securityp. 294
Types of Data Security Measuresp. 296
Backup and Recoveryp. 303
The Importance of Backup and Recoveryp. 303
Backup Copies and Journalsp. 303
Forward Recoveryp. 304
Backward Recoveryp. 305
Duplicate or ''Mirrored'' Databasesp. 306
Disaster Recoveryp. 306
Concurrency Controlp. 308
The Importance of Concurrency Controlp. 308
The Lost Update Problemp. 308
Locks and Deadlockp. 309
Versioningp. 310
Summaryp. 311
Client/Server Database And Distributed Databasep. 315
Introductionp. 316
Client/Server Databasesp. 316
Distributed Databasep. 321
The Distributed Database Conceptp. 321
Concurrency Control in Distributed Databasesp. 325
Distributed Joinsp. 327
Partitioning or Fragmentationp. 329
Distributed Directory Managementp. 330
Distributed DBMSs: Advantages and Disadvantagesp. 331
Summaryp. 332
The Data Warehousep. 335
Introductionp. 336
The Data Warehouse Conceptp. 338
The Data is Subject Orientedp. 338
The Data is Integratedp. 339
The Data is Non-Volatilep. 339
The Data is Time Variantp. 339
The Data Must Be High Qualityp. 340
The Data May Be Aggregatedp. 340
The Data is Often Denormalizedp. 340
The Data is Not Necessarily Absolutely Currentp. 341
Types of Data Warehousesp. 341
The Enterprise Data Warehouse (EDW)p. 342
The Data Mart (DM)p. 342
Which to Choose: The EDW, the DM, or Both?p. 342
Designing a Data Warehousep. 343
Introductionp. 343
General Hardware Co. Data Warehousep. 344
Good Reading Bookstores Data Warehousep. 348
Lucky Rent-A-Car Data Warehousep. 350
What About a World Music Association Data Warehouse?p. 351
Building a Data Warehousep. 352
Introductionp. 352
Data Extractionp. 352
Data Cleaningp. 354
Data Transformationp. 356
Data Loadingp. 356
Using a Data Warehousep. 357
On-Line Analytic Processingp. 357
Data Miningp. 357
Administering a Data Warehousep. 360
Challenges in Data Warehousingp. 361
Summaryp. 362
Databases And The Internetp. 365
Introductionp. 366
Database Connectivity Issuesp. 367
Expanded Set of Data Typesp. 373
Database Control Issuesp. 374
Performancep. 374
Availabilityp. 375
Scalabilityp. 376
Security and Privacyp. 376
Data Extraction into XMLp. 379
Summaryp. 381
Indexp. 385
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.

American Express