Database Concepts
8th Edition
David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder
Instructor’s Manual
Prepared by David J. Auer
Appendix G
Getting Started with Visio 2016
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted,
in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior
written permission of the publisher. Printed in the United States of America.
Instructor’s Manual to accompany:
Database Concepts (8th Edition)
David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder
Appendix G – Getting Started with Microsoft Visio 2016
CHAPTER OBJECTIVES
• Learn how to create E-R data models in Microsoft Visio 2016
CHAPTER ERRATA
These are no known errors at this time. Any errors that are discovered in the future will
be reported and corrected in the online DBC e08 Errata document, which will be
available at http://www.pearsonhighered.com/kroenke.
THE ACCESS WORKBENCH
Solutions to the Access Workbench exercises may be found in Solutions to all Sections:
The Access Workbench, which is a separate document within the Instructor’s Manual.
There is no section of The Access Workbench for this appendix.
NOTES ON MICROSOFT WINDOWS 10
This book uses the Microsoft Windows 10 operating system as the basis for screenshots
and step-by-step instructions. However, with Windows 10, Microsoft has introduced a
continuous update system that has already resulted in some fundamental differences in
how different versions of Windows 10 look and operate.
For example, in the original version of Microsoft Windows 10, clicking the Windows Start
button (or pressing the Windows key on the keyboard) displayed the menu shown in
Figure 1. In this menu, we need to click the All Apps button in order to see the Apps
menu shown in Figure 2.
Appendix G – Getting Started with Microsoft Visio 2016
Figure 1 – Windows 10 Main Menu
Figure 2 – Windows 10 All Apps Menu
Appendix G – Getting Started with Microsoft Visio 2016
Figure 3 – Windows 10 Anniversary Update Main Menu with All Apps Included
Microsoft then released the Windows 10 Anniversary Update (Feature update to
Windows 10, version 1607) (see the blog discussion at
https://blogs.windows.com/windowsexperience/2016/08/02/how-to-get-the-windows-10–
anniversary-update/#K1CZuiw4auiuE9A5.97 ). One of the changes introduced in the
Anniversary Update was a major change to the menu system. Now, as shown in
Figure 3, the Apps menu is immediately available when the Start button is used (or when
the keyboard Windows key is pressed).
Therefore, note that the step by step instructions in this book may need to be altered for
your use depending upon which version of Microsoft Windows 10 you or your students
are using!
We recommend that you update Windows 10 to the Windows 10 Anniversary Update
(Feature update to Windows 10, version 1607), and make sure it is patched with all
updates to that version (at a minimum patched to Windows 10 Version 1607 update for
August 23, 2016 (KB3176936), and the Windows 10 Version 1607 cumulative update for
September 29, 2016 (KB3194496). We also recommend using the 32-bit version of
Microsoft Office. This insures that all the examples discussed in this book will function
properly.
Appendix G – Getting Started with Microsoft Visio 2016
TEACHING SUGGESTIONS
• Be sure your students understand the similarities and differences between a data
model (Chapter 4) and database design (Chapter 5). You may also find it useful to
use Appendix F—Getting Started in Systems Analysis and Design to further
establish the use of data models and database designs in the context of the systems
development Life cycle (SDLC) model.
ANSWERS TO REVIEW QUESTIONS
G.1. What is Microsoft Visio 2016?
G.2. What is the Backstage view?
G.3. How do you create a new database model diagram drawing in Microsoft Visio
2016?
To open a new database model diagram drawing:
G.4. Describe the Shapes window and the objects in the Shapes window.
Appendix G – Getting Started with Microsoft Visio 2016
© 2018 Pearson Education, Inc. Page 7 of 13
• The Minimize the Shapes window button—As the name says, use this to minimize the
Shapes window
• The More Shapes button—Use this to display the More Shapes list, as shown in Figure
D-5, if you need to add additional shape templates to the drawing.
• The Crow’s Foot Database Notation button — Use this to display the Crow’s Foot
Database Notation shapes pane.
G.5. What shapes are included in the Crow’s Foot Database Notation stencil, and
what is the purpose of each shape?
The Entity Relationship (US units) stencil contains all the template objects we will use to build
our data models and database designs. It includes:
G.6. How do you create entities in a data model diagram?
Creating a Table in the Microsoft Visio E-R Diagram:
G.7. When should you use the Relationship connector object?
Appendix G – Getting Started with Microsoft Visio 2016
G.8. How do you format a Relationship connector object so that it displays IE Crow’s Foot E–
R notation?
G.9. How do you connect a Relationship connector object to two tables? What significance is
there to which end of the Relationship connector is attached to which table?
G.10. How are Relationship connector cardinalities set? What is the correspondence between
the cardinality terms used in the database properties window and the IE Crow’s Foot E–
R notation shown in Figure G-20?
Appendix G – Getting Started with Microsoft Visio 2016
© 2018 Pearson Education, Inc. Page 9 of 13
ANSWERS TO EXERCISES
G.11. If you haven’t already done so, work through the steps described in this appendix to
create the data model and database design for the WP database.
Appendix G – Getting Started with Microsoft Visio 2016
G.12. Create a copy of the WP-Data-Model.vsd file, and name it WP-Data-Model-with-
ASSIGNMENT.vsd. Modify the data model to include the ASSIGNMENT as shown in the
SQL statements in Figure G-9.
Appendix G – Getting Started with Microsoft Visio 2016
G.13. The data model for Heather Sweeney Designs is shown in Figure 4-20(c). In Microsoft
Visio 2016, create a new Database Model Diagram drawing named HSD-Data-Model.
Recreate the data model shown in Figure 4-20(c) in this drawing.
Appendix G – Getting Started with Microsoft Visio 2016
Appendix G – Getting Started with Microsoft Visio 2016
G.14. A data model for the Wallingford Motor Customer Relationship Management database is
shown in Figure AW-4-1. In Microsoft Visio 2016, create a new Database Model
Diagram drawing named WMCRM-Data-Model.vsdx, and use it to recreate the data
model shown in Figure AW-4-1.
The solution is in the file DBC-e08-WMCRM-Data-Model.vsd, and is shown below.