Database concepts

Cover......Page 1
Title......Page 5
Copyright......Page 6
Contents......Page 8
Part I Database Fundamentals......Page 19
 Chapter 1 Getting Started: An Overview of Databases......Page 21
  Why Use a Database?......Page 22
  What Is a Database System?......Page 32
  What Is a NOSQL Database?......Page 42
  The Access Workbench Section 1—Getting Started with Microsoft Access......Page 43
  Summary......Page 72
  Review Questions......Page 73
  Exercises......Page 74
  Access Workbench Exercises......Page 75
  San Juan Sailboat Charters Case Questions......Page 77
  Garden Glory Project Questions......Page 78
  The Queen Anne Curiosity Shop Project Questions......Page 79
 Chapter 2 The Relational Model and Database Normalization......Page 80
  Relations......Page 81
  Types of Keys......Page 84
  The Problem of Nul Values......Page 92
  Functional Dependencies and Normalization......Page 94
  Normal Forms: One Step at a Time......Page 106
  The Access Workbench Section 2—Working with Multiple Tables in Microsoft Access......Page 107
  Summary......Page 123
  Review Questions......Page 124
  Exercises......Page 126
  Access Workbench Exercises......Page 128
  Regional Labs Case Questions......Page 131
  Garden Glory Project Questions......Page 132
  The Queen Anne Curiosity Shop Project Questions......Page 134
 Chapter 3 Structured Query Language......Page 137
  An Example Database......Page 138
  SQL for Data Definition (DDL)—Creating Tables and Relationships......Page 144
  SQL for Data Manipulation (DML)—Inserting Data......Page 157
  SQL for Data Manipulation (DML)—Single Table Queries......Page 161
  SQL for Data Manipulation (DML)— Multiple Table Queries......Page 179
  SQL for Data Manipulation (DML)—Data Modification and Deletion......Page 194
  SQL for Data Definition (DDL)—Table and Constraint Modification and Deletion......Page 197
  The Access Workbench Section 3—Working with Queries in Microsoft Access......Page 200
  Summary......Page 229
  Review Questions......Page 230
  Exercises......Page 234
  Access Workbench Exercises......Page 236
  Heather Sweeney Designs Case Questions......Page 240
  Garden Glory Project Questions......Page 250
  James River Jewelry Project Questions (See Online Appendix D)......Page 253
  The Queen Anne Curiosity Shop Project Questions......Page 254
Part II Database Design......Page 261
 Chapter 4 Data Modeling and the Entity-Relationship Model......Page 263
  Requirements Analysis......Page 264
  The Entity-Relationship Data Model......Page 265
  Entity-Relationship Diagrams......Page 270
  Developing an Example E-R Diagram......Page 280
  The Access Workbench Section 4—Prototyping Using Microsoft Access......Page 288
  Summary......Page 297
  Review Questions......Page 298
  Exercises......Page 299
  Highline University Mentor Program Case Questions......Page 300
  Washington State Patrol Case Questions......Page 302
  Garden Glory Project Questions......Page 303
  The Queen Anne Curiosity Shop Project Questions......Page 304
 Chapter 5 Database Design......Page 305
  Transforming a Data Model into a Database Design......Page 306
  Representing Entities with the Relational Model......Page 307
  Representing Relationships......Page 315
  Database Design at Heather Sweeney Designs......Page 328
  The Access Workbench Section 5—Relationships in Microsoft Access......Page 336
  Summary......Page 342
  Review Questions......Page 343
  Exercises......Page 344
  Access Workbench Exercises......Page 345
  San Juan Sailboat Charters Case Questions......Page 346
  James River Jewelry Project Questions (See Online Appendix D)......Page 348
  The Queen Anne Curiosity Shop Project Questions......Page 349
Part III Database Management......Page 351
 Chapter 6 Database Administration and Management......Page 353
  The Need for Control, Security, and Reliability......Page 354
  Concurrency Control......Page 356
  SQL Transaction Control Language and Declaring Lock Characteristics......Page 362
  Cursor Types......Page 366
  Database Security......Page 368
  Database Backup and Recovery......Page 375
  The Access Workbench Section 6—Database Administration in Microsoft Access......Page 379
  Summary......Page 399
  Review Questions......Page 401
  Exercises......Page 403
  Access Workbench Exercises......Page 404
  Marcia’s Dry Cleaning Case Questions......Page 405
  Garden Glory Project Questions......Page 406
  James River Jewelry Project Questions (See Online Appendix D)......Page 407
  The Queen Anne Curiosity Shop Project Questions......Page 408
 Chapter 7 Database Processing in Applications......Page 410
  The Database Processing Environment......Page 411
  Web Application Database Processing......Page 414
  Database Processing and XML......Page 442
  The Access Workbench Section 7—Web Database Processing Using Microsoft Access......Page 444
  Summary......Page 453
  Review Questions......Page 454
  Exercises......Page 456
  Marcia’s Dry Cleaning Case Questions......Page 458
  Garden Glory Project Questions......Page 460
  James River Jewelry Project Questions (See Online Appendix D)......Page 461
  The Queen Anne Curiosity Shop Project Questions......Page 462
 Chapter 8 Big Data, Data Warehouses, and Business Intelligence Systems......Page 463
  The Relationship Between Operational and BI Systems......Page 465
  Reporting Systems and Data Mining Applications......Page 466
  Data Warehouses and Data Marts......Page 467
  OLAP......Page 476
  Distributed Database Processing......Page 481
  Big Data and the Not Only SQL Movement......Page 484
  The Access Workbench Section 8—Business Intelligence Systems Using Microsoft Access......Page 489
  Summary......Page 502
  Review Questions......Page 503
  Exercises......Page 505
  Access Workbench Exercises......Page 506
  Marcia’s Dry Cleaning Case Questions......Page 507
  James River Jewelry Project Questions (See Online Appendix D)......Page 508
  The Queen Anne Curiosity Shop Project Questions......Page 509
Glossary......Page 513
 D......Page 521
 E......Page 522
 L......Page 523
 O......Page 524
 R......Page 525
 T......Page 526
 X......Page 527
 Z03_KROE6232_07_GE_IDX......Page 0