Database Concepts, Global Edition

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 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 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. The full text downloaded to your computer With eBooks you can: search for key concepts, words and phrases make highlights and notes as you study share your notes with friends eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps. Upon purchase, you'll gain instant access to this eBook. Time limit The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed. 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. -- Provided by publisher Here is 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