Additional Information
Book Details
Abstract
For undergraduate database management students or business professionals
Here’s practical help for understanding, creating, and managing small databases—from two of the world’s leading database authorities. Database Concepts by David Kroenke and David Auer gives undergraduate database management students and business professionals alike a firm understanding of the concepts behind the software, using Access 2013 to illustrate the concepts and techniques. Three projects run throughout the text, to show students how to apply the concepts to real-life business situations. The text provides flexibility for choosing the software instructors want to use in class; allows students to work with new, complete databases, including Wedgewood Pacific Corporation, Heather Sweeney Designs, and Wallingford Motors; and includes coverage for some of the latest information on databases available.
Teaching and Learning Experience
This text will provide a better teaching and learning experience–for you and your students. Here's how:
- Provides a firm understanding of the concepts behind the software
- Uses Access 2013 to illustrate the concepts and techniques while also providing flexibility to choose the software used in class
- Allows students to work with new, complete databases
- Includes coverage of some of the latest information available
Table of Contents
| Section Title | Page | Action | Price |
|---|---|---|---|
| Cover | Cover | ||
| Brief Contents | 5 | ||
| Contents | 6 | ||
| Part I: Database Fundamentals | 17 | ||
| Chapter 1: Getting Started: An Overview of Databases | 19 | ||
| Why Use a Database? | 20 | ||
| Problems with Lists | 20 | ||
| Using Relational Database Tables | 22 | ||
| Processing Relational Tables | 27 | ||
| What Is a Database System? | 30 | ||
| The Database | 30 | ||
| The DBMS | 31 | ||
| Personal Versus Enterprise-Class Database Systems | 35 | ||
| What Is a NoSQL Database? | 40 | ||
| The Access Workbench Section 1—Getting Started with Microsoft Access | 41 | ||
| Summary | 70 | ||
| Key Terms | 71 | ||
| Review Questions | 71 | ||
| Exercises | 72 | ||
| Access Workbench Key Terms | 73 | ||
| Access Workbench Exercises | 73 | ||
| San Juan Sailboat Charters Case Questions | 75 | ||
| Garden Glory Project Questions | 76 | ||
| James River Jewelry Project Questions (See Online Appendix D) | 77 | ||
| The Queen Anne Curiosity Shop Project Questions | 77 | ||
| Chapter 2: The Relational Model and Database Normalization | 78 | ||
| Relations | 79 | ||
| A Sample Relation and Two Nonrelations | 79 | ||
| A Note on Presenting Relation Structures | 81 | ||
| A Note on Terminology | 81 | ||
| Types of Keys | 82 | ||
| Composite Keys | 82 | ||
| Candidate and Primary Keys | 82 | ||
| Surrogate Keys | 86 | ||
| Foreign Keys and Referential Integrity | 87 | ||
| The Problem of Null Values | 90 | ||
| Functional Dependencies and Normalization | 92 | ||
| Functional Dependencies | 92 | ||
| Primary and Candidate Keys Revisited | 93 | ||
| Normalization | 94 | ||
| Relational Design Principles | 95 | ||
| The Normalization Process | 95 | ||
| Normalization Examples | 97 | ||
| Eliminating Anomalies from Multivalued Dependencies | 102 | ||
| Normal Forms: One Step at a Time | 104 | ||
| The Access Workbench Section 2—Working with Multiple Tables in Microsoft Access | 105 | ||
| Summary | 121 | ||
| Key Terms | 122 | ||
| Review Questions | 122 | ||
| Exercises | 124 | ||
| Access Workbench Key Terms | 126 | ||
| Access Workbench Exercises | 126 | ||
| Regional Labs Case Questions | 129 | ||
| Garden Glory Project Questions | 130 | ||
| James River Jewelry Project Questions (See Online Appendix D) | 132 | ||
| The Queen Anne Curiosity Shop Project Questions | 132 | ||
| Chapter 3: Structured Query Language | 135 | ||
| An Example Database | 136 | ||
| Does Not Work with Microsoft Access ANSI-89 SQL | 140 | ||
| SQL for Data Definition (DDL)—Creating Tables and Relationships | 142 | ||
| Defining Primary Keys with Table Constraints | 150 | ||
| Defining Foreign Keys with the Table Constraints | 151 | ||
| Submitting SQL to the DBMS | 153 | ||
| SQL for Data Manipulation (DML)—Inserting Data | 155 | ||
| Inserting Data | 156 | ||
| SQL for Data Manipulation (DML)—Single Table Queries | 159 | ||
| The SQL SELECT/FROM/WHERE Framework | 160 | ||
| Reading Specified Columns from a Single Table | 160 | ||
| Reading Specified Rows from a Single Table | 163 | ||
| Reading Specified Columns and Specified Rows from a Single Table | 165 | ||
| Ranges, Wildcards, and Nulls in WHERE Clauses | 167 | ||
| Sorting the Results of a Query | 170 | ||
| SQL Built-in Functions and Calculations | 172 | ||
| Built-in Functions and Grouping | 175 | ||
| SQL for Data Manipulation (DML)— Multiple Table Queries | 177 | ||
| Querying Multiple Tables with Subqueries | 177 | ||
| Querying Multiple Tables with Joins | 179 | ||
| The SQL JOIN ON Syntax | 184 | ||
| Inner Joins and Outer Joins | 186 | ||
| SQL for Data Manipulation (DML)—Data Modification and Deletion | 192 | ||
| Modifying Data | 192 | ||
| Deleting Data | 194 | ||
| SQL for Data Definition (DDL)—Table and Constraint Modification and Deletion | 195 | ||
| The SQL DROP TABLE Statement | 195 | ||
| The SQL ALTER TABLE Statement | 196 | ||
| The SQL TRUNCATE TABLE Statement | 196 | ||
| The CHECK Constraint | 196 | ||
| SQL Views | 198 | ||
| The Access Workbench Section 3—Working with Queries in Microsoft Access | 198 | ||
| Summary | 227 | ||
| Key Terms | 228 | ||
| Review Questions | 228 | ||
| Exercises | 232 | ||
| Access Workbench Key Terms | 234 | ||
| Access Workbench Exercises | 234 | ||
| Heather Sweeney Designs Case Questions | 238 | ||
| Garden Glory Project Questions | 248 | ||
| James River Jewelry Project Questions (See Online Appendix D | 251 | ||
| The Queen Anne Curiosity Shop Project Questions | 252 | ||
| Part 2: Database Design | 259 | ||
| Chapter 4: Data Modeling and the Entity-Relationship Model | 261 | ||
| Requirements Analysis | 262 | ||
| The Entity-Relationship Data Model | 263 | ||
| Entities | 263 | ||
| Attributes | 264 | ||
| Identifiers | 264 | ||
| Relationships | 265 | ||
| Entity-Relationship Diagrams | 268 | ||
| Variations of the E-R Model | 268 | ||
| The IE Crow’s Foot E-R Model | 269 | ||
| Weak Entities | 271 | ||
| ID-Dependent Entities | 271 | ||
| Non–ID-Dependent Weak Entities | 273 | ||
| Associative Entities | 275 | ||
| Subtype Entities | 276 | ||
| Recursive Relationships | 277 | ||
| Developing an Example E-R Diagram | 278 | ||
| Heather Sweeney Designs | 278 | ||
| The Seminar Customer List | 278 | ||
| The Customer Form Letter | 280 | ||
| The Sales Invoice | 281 | ||
| Attribute Specifications | 285 | ||
| Business Rules | 285 | ||
| Validating the Data Model | 285 | ||
| The Access Workbench Section 4—Prototyping Using Microsoft Access | 286 | ||
| Summary | 295 | ||
| Key Terms | 296 | ||
| Review Questions | 296 | ||
| Exercises | 297 | ||
| Access Workbench Key Terms | 298 | ||
| Access Workbench Exercises | 298 | ||
| Highline University Mentor Program Case Questions | 298 | ||
| Washington State Patrol Case Questions | 300 | ||
| Garden Glory Project Questions | 301 | ||
| James River Jewelry Project Questions (See Online Appendix D) | 302 | ||
| The Queen Anne Curiosity Shop Project Questions | 302 | ||
| Chapter 5: Database Design | 303 | ||
| The Purpose of a Database Design | 304 | ||
| Transforming a Data Model into a Database Design | 304 | ||
| Representing Entities with the Relational Model | 305 | ||
| Representing the ITEM Entity | 305 | ||
| Representing the CUSTOMER Entity | 307 | ||
| Denormalization | 309 | ||
| A Relational Design for the SALES_COMMISSION Entity | 310 | ||
| Representing Weak Entities | 311 | ||
| Representing Relationships | 313 | ||
| Relationships Between Strong Entities | 313 | ||
| Relationships Using Weak Entities | 320 | ||
| Relationships with Subtypes | 322 | ||
| Representing Recursive Relationships | 322 | ||
| Database Design at Heather Sweeney Designs | 326 | ||
| Weak Entities | 326 | ||
| Verifying Normalization | 326 | ||
| Specifying Column Properties | 327 | ||
| Relationships | 327 | ||
| Enforcing Referential Integrity | 330 | ||
| The Access Workbench Section 5—Relationships in Microsoft Access | 334 | ||
| Summary | 340 | ||
| Key Terms | 341 | ||
| Review Questions | 341 | ||
| Exercises | 342 | ||
| Access Workbench Key Terms | 343 | ||
| Access Workbench Exercises | 343 | ||
| San Juan Sailboat Charters Case Questions | 344 | ||
| Washington State Patrol Case Questions | 346 | ||
| Garden Glory Project Questions | 346 | ||
| James River Jewelry Project Questions (See Online Appendix D) | 346 | ||
| The Queen Anne Curiosity Shop Project Questions | 347 | ||
| Part 3: Database Management | 349 | ||
| Chapter 6: Database Administration and Management | 351 | ||
| The Heather Sweeney Designs Database | 352 | ||
| The Need for Control, Security, and Reliability | 352 | ||
| Concurrency Control | 354 | ||
| The Need for Atomic Transactions | 354 | ||
| Concurrent Transaction Processing | 355 | ||
| The Lost Update Problem | 356 | ||
| Resource Locking | 357 | ||
| Serializable Transactions | 358 | ||
| Deadlock | 358 | ||
| Optimistic Versus Pessimistic Locking | 358 | ||
| SQL Transaction Control Language and Declaring Lock Characteristics | 360 | ||
| Consistent Transactions | 362 | ||
| Transaction Isolation Level | 363 | ||
| Cursor Types | 364 | ||
| Database Security | 366 | ||
| User Accounts | 367 | ||
| User Processing Rights and Responsibilities | 367 | ||
| DBMS-Level Security | 371 | ||
| Application-Level Security | 372 | ||
| Database Backup and Recovery | 373 | ||
| Recovery via Reprocessing | 373 | ||
| Recovery via Rollback and Rollforward | 374 | ||
| Additional DBA Responsibilities | 377 | ||
| The Access Workbench Section 6—Database Administration in Microsoft Access | 377 | ||
| Summary | 397 | ||
| Key Terms | 399 | ||
| Review Questions | 399 | ||
| Exercises | 401 | ||
| Access Workbench Key Terms | 402 | ||
| Access Workbench Exercises | 402 | ||
| Marcia’s Dry Cleaning Case Questions | 403 | ||
| Garden Glory Project Questions | 404 | ||
| James River Jewelry Project Questions (See Online Appendix D) | 405 | ||
| The Queen Anne Curiosity Shop Project Questions | 406 | ||
| Chapter 7: Database Processing in Applications | 408 | ||
| The Database Processing Environment | 409 | ||
| Queries, Forms, and Reports | 409 | ||
| Client/Server and Traditional Application Processing | 410 | ||
| SQL/PSM: User-Defined Functions, Stored Procedures, and Triggers | 411 | ||
| Web Application Database Processing | 412 | ||
| ODBC | 414 | ||
| Web Processing with the Microsoft IIS | 418 | ||
| Getting Started with HTML Web Pages | 420 | ||
| The index.html Web Page | 421 | ||
| Creating the index.html Web Page | 422 | ||
| Web Database Processing Using PHP | 423 | ||
| Updating a Table with PHP | 431 | ||
| Challenges for Web Database Processing | 436 | ||
| SQL Injection Attacks | 439 | ||
| Database Processing and XML | 440 | ||
| The Importance of XML | 440 | ||
| XML as a Markup Language | 440 | ||
| XML and Database Processing | 440 | ||
| XML Web Services | 441 | ||
| The Access Workbench Section 7—Web Database Processing Using Microsoft Access | 442 | ||
| Summary | 451 | ||
| Key Terms | 452 | ||
| Review Questions | 452 | ||
| Exercises | 454 | ||
| Access Workbench Exercises | 456 | ||
| Marcia’s Dry Cleaning Case Questions | 456 | ||
| Garden Glory Project Questions | 458 | ||
| James River Jewelry Project Questions (See Online Appendix D) | 459 | ||
| The Queen Anne Curiosity Shop Project Questions | 460 | ||
| Chapter 8: Big Data, Data Warehouses, and Business Intelligence Systems | 461 | ||
| Business Intelligence Systems | 463 | ||
| The Relationship Between Operational and BI Systems | 463 | ||
| Reporting Systems and Data Mining Applications | 464 | ||
| Reporting Systems | 464 | ||
| Data Mining Applications | 465 | ||
| Data Warehouses and Data Marts | 465 | ||
| The Components of a Data Warehouse | 465 | ||
| Data Warehouses Versus Data Marts | 467 | ||
| Dimensional Databases | 468 | ||
| OLAP | 474 | ||
| Distributed Database Processing | 479 | ||
| Types of Distributed Databases | 480 | ||
| Challenges of Distributed Databases | 481 | ||
| Object-Relational Databases | 482 | ||
| Big Data and the Not Only SQL Movement | 482 | ||
| Column Family Databases | 483 | ||
| MapReduce | 485 | ||
| Hadoop | 485 | ||
| The Access Workbench Section 8—Business Intelligence Systems Using Microsoft Access | 487 | ||
| Summary | 500 | ||
| Key Terms | 501 | ||
| Review Questions | 501 | ||
| Exercises | 503 | ||
| Access Workbench Exercises | 504 | ||
| Marcia’s Dry Cleaning Case Questions | 505 | ||
| Garden Glory Project Questions | 506 | ||
| James River Jewelry Project Questions | 506 | ||
| The Queen Anne Curiosity Shop Project Questions | 507 | ||
| Online Appendices | 509 | ||
| Glossary | 511 | ||
| Index | 519 |