100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Solution Manual for Database Concepts, 10th Edition by David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder R332,62   Add to cart

Exam (elaborations)

Solution Manual for Database Concepts, 10th Edition by David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder

1 review
 130 views  7 purchases
  • Course
  • Solution Manual
  • Institution
  • Solution Manual

Solution Manual for Database Concepts 10th Edition by David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder

Preview 4 out of 1488  pages

  • January 20, 2024
  • 1488
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers
  • Solution Manual
  • Solution Manual

1  review

review-writer-avatar

By: natthaweeilac • 5 months ago

avatar-seller
Database Concepts
10th Edition

David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder


Instructor’s Manual
Prepared by Scott L. Vandenberg




Chapter One
Getting Started

,Instructor’s Manual to accompany:

Database Concepts (10th Edition)

, David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder
© 2024, 2020, 2017, 2015, 2013, 2011, 2010, 2008 Pearson Education, Inc.

 CHAPTER OBJECTIVES
• Understand the importance of databases today.
• Understand why and how databases are used.
• Describe the components of a database system.
• Understand the difference between personal and enterprise-class database systems.
• Describe Web database applications.
• Describe data warehouses and business intelligence (BI) systems.
• Define Big Data.
• Understand the basics of cloud computing and cloud-based databases.
• Learn to use Microsoft Access to create and implement databases.
• Gain practice with databases by working with Case Studies.
• Gain practice with databases by working with ongoing Projects.

 CHAPTER ERRATA
These are the known errors at this time. Any errors that are discovered in the future will
be reported and corrected in the online DBC e10 Errata document or in this file, which
will be available at http://www.pearson.com/kroenke.

 WORKING WITH MICROSOFT ACCESS
Solutions to the Working with Microsoft Access exercises may be found in Solutions to
all Sections: Working with Microsoft Access, which is a separate document within the
Instructor’s Manual.

 WARNING: CHANGES IN GRAPHICAL USER INTERFACES

You and your students need to be aware that changes in graphical user interface (GUI)
designs can occur without warning, and therefore you may see slightly different user
interface colors, icons, text, and item placement than shown in the figures in this book or
instructor manual.

Until recently, changes to GUI designs only occurred when a new major version of an
application was released. For example, after Microsoft Office 2010 was released, we
would not expect to see changes to the GUI for Microsoft Excel, Microsoft Access,
Microsoft Word, Microsoft PowerPoint, and other associated Microsoft Office
applications until the next major version, Microsoft Office 2013, was released. The GUI
was stable, and screenshots of the Microsoft Office products for books using Office 2010
would be accurate.

Now, however, we have entered an era of continuously updating revisions within major
versions. The next product update, automatically scheduled and installed on your

, computer, may, without warning, change the GUI. While we have seen this happen with
MySQL, and particularly with the MySQL Workbench, we are now seeing it happen with
Microsoft 365 and Microsoft Office 2021 (which is a standardized subset of Microsoft
365).

Of particular note with Microsoft 365 and Microsoft Office 2021 is the Microsoft Office
“visual refresh”. This is a change to the interface to make it conform more closely to
Windows 11 design standards. The main differences are cosmetic, including rounded
corners and different placement of some items from the Quick Access Toolbar.
However, this visual refresh is independent of versioning: You may have a later version
than someone with the visual refresh, yet not yet have it yourself. Fortunately, for the
purposes of learning Microsoft Access, these changes are not substantive, but you and
your students should be aware of them.

Note that these changes do not affect the basic functionality of the Office
programs. The steps to use Microsoft Access and Microsoft Excel described in
Database Concepts 10th edition are still largely the same!

However, you and your students need to be aware that what you see in Microsoft
Access and Microsoft Excel may differ somewhat from what we captured in the screen
shots used in this book. And you should now expect future changes in the Microsoft
Office GUI, and in the GUIs for other products (MySQL Workbench is an example), to
occur without warning. It is simply a consequence of the new “constant update” system
of delivering software as well as the subscription-based (versus locally-installed and
license-based) nature of software. This is especially true of cloud-based software, which
often changes without warning.

We recommend that you cover this topic with your students!

 TEACHING SUGGESTIONS
• The Art Course database discussed in Chapter One is a good database to use for an
in-class demo of the concepts in this chapter. Note that this 10th edition emphasizes
Access and MySQL, with less support for Microsoft SQL Server and Oracle
Database Express Edition. See the list, data, and database files supplied, and use
the following material:
• Microsoft Access 2021:
• DBC-e10-Art-Course-Database-CH01.accdb
• MySQL 8.0:
• DBC-e10-MySQL-Art-Course-Database-Create-Tables.sql
• DBC-e10-MySQL-Art-Course-Database-Insert-Data.sql
• DBC-e10-MySQL-Art-Course-Database-SQL-Queries-CH01.sql
• Introduce the course by explaining that database processing is at the heart of all
applications today. Use the material in the section “The Importance of Databases

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying this summary from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller solutions. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy this summary for R332,62. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

79271 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy summaries for 14 years now

Start selling
R332,62  7x  sold
  • (1)
  Buy now