Database Concepts

Description

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 gives undergraduate database management students and business professionals alike a firm understanding of the concepts behind the software, using Access 2016 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, 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

• PAR T   1      DATABASE FUNDAMENTALS      
• 1   Getting Started     
• 2   The Relational Model     
• 3   Structured Query Language     
• PAR T   2      DATABASE DESIGN       
• 4    Data Modeling and the Entity- Relationship Model         
• 5   Database Design     
• PAR T   3      DATABASE MANAGEMENT       
• 6   Database Administration    
• 7   Database Processes
• Applications     
• 8   Data Warehouses, Business Intelligence Systems, and Big Data      
• Glossary    
• Index     

David M. Kroenke entered  the computing profession as a summer intern at the RAND Corporation  in 1967. Since then, his career has spanned  education,  industry, consulting, and publishing.

He has taught at the University of Washington, Colorado State University, and Seattle University. Over the years, he has led dozens of teaching seminars for college professors. In 1991 the International Association of Information Systems named him Computer Educator of the Year.

In  industry,  Kroenke  has  worked  for  the  U.S. Air  Force  and  Boeing Computer Services, and he was a principal in the startup of three companies. He was also vice presi- dent of product  marketing and development for the Microrim Corporation  and was chief technologist for the database division of Wall Data, Inc. He is the father of the semantic object data model. Kroenke’s consulting clients include IBM Corporation,  Microsoft, Computer Sciences Corporation,  and numerous other companies and organizations.

His text Database Processing: Fundamentals, Design, and Implementation,  first pub- lished in 1977, is now in its 14th edition (coauthored  with David Auer for the 11th, 12th, 13th, and 14th editions). He introduced  Database Concepts (now in the eighth edition that you are reading) in 2003. Kroenke has published many other textbooks, including the clas- sic Business Computer Systems (1981). Recently, he has authored  Using MIS (8th edition), Experiencing MIS  (6th  edition),  MIS  Essentials (4th  edition),  Processes, Systems  and Information: An Introduction to MIS (2nd edition) (coauthored  with Earl McKinney), and Essentials of Processes, Systems and Information (coauthored with Earl McKinney).

An avid sailor, Kroenke also wrote Know Your Boat: The Guide to Everything That Makes Your Boat Work. Kroenke lives in Seattle, Washington. He is married and has two children and three grandchildren.

David J. Auer is a Senior Instructor Emeritus at the College of Business (CBE) of Western Washington  University in  Bellingham, WA.  He  served  as the  director  of Information Systems and Technology Services at CBE from 1994 to 2014 and taught in CBE’s Department  of Decision Sciences from 1981 to 2015. He has taught CBE courses in quan- titative methods, production  and operations management, statistics, finance, and manage- ment information systems. Besides managing CBE’s computer,  network, and other technology resources, he also teaches management information  systems courses. He has taught the Principles of Management Information  Systems and Business Database Development courses, and he was responsible for developing CBE’s network infrastructure courses, including Computer Hardware and Operating Systems, Telecommunications, and Network Administration.

 He  has  coauthored  several MIS-related  textbooks,  including  Database Processing: Fundamentals, Design, and Implementation, first published in 1977, is now in its 14th edi- tion (coauthored with David Kroenke for the 11th, 12th, 13th, and 14th editions), and Database Concepts, now  in  the  eighth  edition  that  you  are  reading  (coauthored  with David Kroenke for the 3rd, 4th, 5th, 6th, and 7th editions).

 Auer holds a bachelor’s degree in English literature from the University of Washington, a bachelor’s degree in mathematics  and economics from Western  Washington  University, a master’s degree in economics from Western Washington University, and a master’s degree in counseling psychology from Western Washington University. He served as a commissioned officer in the U.S. Air Force, and he has also worked as an organizational development specialist and therapist for an employee assistance program (EAP).

Auer and his wife, Donna, live in Bellingham, Washington. He has two children and four grandchildren.

Scott L. Vandenberg has been on the Computer Science faculty at Siena College since 1993, where he regularly teaches three different database courses at several levels to both computer science and business majors. Prior to arriving at Siena, he taught undergraduate and  graduate  courses in database  systems at the  University of Massachusetts—Amherst. Since arriving at Siena, he also taught graduate and undergraduate  database courses at the University of Washington—Seattle. He has developed five different database courses over this time. His other teaching experience includes introductory computer science, introduc- tory programming, data structures, management information systems, and three years teaching Siena’s required interdisciplinary freshman writing course.

 Vandenberg’s recent research publications are mainly in the areas of computer science education and data science applications, with earlier work on query optimization and alge- braic query languages. He holds a bachelor’s degree in mathematics and computer science from Cornell University and master’s and PhD degrees in computer science from the University of Wisconsin—Madison. Medieval history and playing hockey are two things that can tear him away from a database. Vandenberg lives in Averill Park, NY, with his wife, Kristin, and two children.

Robert C. Yoder began his professional career at the University at Albany as a systems pro-grammer managing mainframes and Unix servers. He has two years of research experience working on 3-D solid modeling systems. Robert holds BS and MS degrees in computer science and a PhD in information science, all from the University at Albany.

 Yoder joined the Computer Science department at Siena College in 2001 and teaches Business Database, Management Information  Systems, Geographic  Information  Systems, Data Structures, Networks, and Operating Systems courses. Yoder lives in Niskayuna, NY, with his wife, Diane, and two children and enjoys traveling, hiking, and walking his dog.

• The material on Structured Query Language in Chapter 3 has been recognized and expanded to provide a more concise and comprehensive presentation of SQL topics. New material to illustrate the concepts of SQL joins has been added to Chapter 3 to make this material easier for students to understand
• The discussion of SQL is continued in a revised and expanded Appendix E, which is now retitled as “Advanced SQL”, and which continues a discussion of the SQL ALTER statement, SQL set operators (UNION), SQL correlated sub queries, SQL views an SQL/Persistent Stored Modules (SQL/PSM).
• Microsoft Office 2016, and particularly Microsoft Access 2016, is now the basic software used in the book and is shown running on Microsoft Windows 10.
• DBMS software coverage has been updated to include Microsoft SQL Server 2016 Developer Edition, which is now freely available from Microsoft and which has the full functionality of the Microsoft SQL Server Enterprise edition.
• DBMS software coverage has been updated to include MySQL 5.7 Community Server.
• DBMS software coverage on Microsoft SQL Server 2016 (Appendix A), Oracle Database Express Edition (Oracle Database XE) (Appendix B) and MySQL 5.7 Community Server (Appendix C) has been extended, and now includes detailed cover of software installation and configuration.
•  The discussions of importing Microsoft Excel DATE into a DBMS table has been moved from Appendix E into the specific coverage of each of the DBMS products – see coverage of Microsoft SQL Server 2016 in Appendix A, of Oracle Database Express Edition 9Oracle Database XE) in Appendix B, and of MySQL 5.7 Community Server in Appendix C.
• Chapter 8 has been updated to include material on cloud computing and virtualization in addition to revisions tying together the various topics of the chapter. This gives a more complete, contextualized treatment of Big Data and its various facets and relationships to the other topics.
• Appendices J and K continue to expand on Chapter 8. Coverage of decision trees is added to Appendix J at a level similar to that of the coverage of market basket analysis. Appendix K now includes coverage of JSON modeling (and retains the XML coverage) for document-based NoSQL databases. Appendix K also now includes basic coverage and examples of a document-based NoSQL database management system, MongoDB.

We kept all the main innovations included in DBC e06 and DBC e07, including:

• The coverage of Web database applications in Chapter 7 now includes data input Web form pages. This allows Web database applications to be built with both data-input and data-reading Web pages.
• The coverage of Microsoft Access 2016 now includes Microsoft Access switchboard forms (covered in Appendix H, “The Access Workbench – Section H – Microsoft Access 2016 Switchboards”), which are used to build menus for database applications. Switchboard forms can be used to build database applications that have a user-friendly main menu that users can use to display forms, print reports, and run queries.
• Each chapter now features an independent Case Question set. The Case Question sets are problem sets that generally do not require the student to have completed work on the same case in a previous chapter (there is one intentional exception that ties data modeling and database design together). Although in some instances the same basic named case may be used in different chapters, each instance is still completely independent of any other instance.
• Material on SQL programming via SQL/Persistent Stored Modules (SQL/PSM) has been added to Appendix E to provide a better-organized and expanded discussion of this material, which had previously been spread among other parts of the book.

• Provides information on how to create a database management system, regardless of the specific software involved.
• Helps students absorb the process of database creation and implementation, rather than simply the steps in one program.
• Uses the latest software to illustrate the concepts and techniques while also providing flexibility to choose the software used in class.
• Allows students to work with complete databases
• Fully developed data sets for three example databases run throughout various portions of the book, including: Wedgewood Pacific Corporation, Heather Sweeney Designs, and Wallingford Motors.
• BTW: Boxed featured that calls out important, relevant information to students.
• Wide Screen Images: Showing a view of the applications content similar to what the student sees.
• The Access Workbench: Set in chapter and focuses on one of the three running cases (Wedgewood Pacific, Heather Sweeney Designs, and Wallingford Motors) and applies database skills hands-on in Microsoft Access 2016.
• End of Chapter: Includes Chapter Summary, Key Terms, Review Questions, and Exercises
• End of Chapter Access Workbench: Set at the end of chapter, and focuses on one of the three running cases (Wedgewood Pacific, Heather Sweeney Designs, and Wallingford Motors) and applies database skills hands-on in Microsoft Access 2016.
• Case Questions: Introduces a real world case and requires students to think about data and data management while answering questions.
• Projects & Questions: Introduces illustrative cases like Garden Glory, James River Jewelry, Queen Anne Curiosity Shop and asks students to review the databases and project guidelines, and produce answers to the questions which require students to critically think about the management of the data. Garden Glory, concerns the development and use of a database for a partnership that provides gardening and yard maintenance services to individuals and organizations. The second project, James River Jewelry, addresses the need for a database to support a frequent-buyer program for a retail store. The third project, The Queen Anne Curiosity Shop, concerns the sales and inventory needs of a retail business.