Transcript Appendix G - Getting Started with Microsoft Visio

DAVID M. KROENKE and DAVID J. AUER
DATABASE CONCEPTS, 6th Edition
Appendix G
Getting Started with
Microsoft Visio 2010
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.
Copyright © 2013 Pearson Education, Inc.
Publishing as Prentice Hall
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-2
Appendix Objectives
• Learn how to create data models in
Microsoft Visio 2010
• Learn how to create database
designs in Microsoft Visio 2010
• Understand that Microsoft Visio 2010
has a template for creating process
diagrams using Business Processing
Modeling Notation (BPMN)
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-3
The Database Model Diagram
• Microsoft Visio 2010 uses the
Database Model Diagram template
as the basis for:
– Data models (Chapter 4)
– Database designs (Chapter 5)
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-4
The Microsoft Visio 2010 Backstage View
New Tab
Figure G-1: The Microsoft Visio 2010 Backstage View – New Tab
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-5
The Software and Database Templates
Figure G-2: The Software and Database Templates
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-6
The Database Model Diagram Template
Figure G-3: The Database Model Diagram Template
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-7
The Microsoft Visio 2010
Database Model Diagram
Figure G-4: The Microsoft Visio 2010 Database Model Diagram
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-8
The Shapes Window
Figure G-5: The Shapes Window
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-9
The Entity Relationship (US units)
Stencil Objects I
Figure G-6: The Entity Relationship (US units) Stencil Objects
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-10
The Entity Relationship (US units)
Stencil Objects II
• The Entity object—Use this object to create
entities (data model) and tables (database design)
in the Microsoft Visio database model diagram.
• The Relationship object—Use this object to create
relationships between tables in database designs.
• The Dynamic connector object—Use this object
to create relationships between entities in data
models.
• The View object—Use this object to create SQL
views (discussed in Chapter 3A) to data models
and database designs.
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-11
The Entity Relationship (US units)
Stencil Objects III
• The Category object—Use this object to create
supertype/subtype relationships in data models
and database designs.
• The Parent to category connector object—Use
this object to create supertype/subtype
relationships in database designs.
• The Category to child connector object—Use this
object to create supertype/subtype relationships in
database designs.
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-12
The Microsoft Visio 2010
Database Model Diagram
with Minimized Shapes Window
Figure G-7:
The Microsoft Visio 2010 Database Model Diagram with Minimized Shapes Window
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-13
SQL CREATE TABLE DEPARTMENT Statement
Figure G-8: The WPC Database Table SQL Statements
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-14
The Table1 Table Object
Figure G-9: The Table1 Table Object
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-15
Database Properties – Definition
Window
Figure G-10: The Database Properties—Definition Window
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-16
Adding the Primary Key Column
Figure G-11: Adding the Primary Key Column
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-17
The Data Type Drop-Down List
Figure G-12: The Data Type Drop-Down List
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-18
The Completed DepartmentName
Primary Key Column
Figure G-13: The Completed DepartmentName Primary Key Column
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-19
The Completed DEPARTMENT Table
Figure G-14: The Completed DEPARTMENT Table
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-20
The Completed DEPARTMENT,
EMPLOYEE and PROJECT Tables
Figure G-15:
The Completed DEPARTMENT, EMPLOYEE and PROJECT Tables
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-21
Data Models versus Database Designs
• In Microsoft Visio 2010 we use
different connector objects when
building Data models (Chapter 4)
and Database designs (Chapter 5).
– The Dynamic connector—Used between two
entities, this is just a line, and has no primary
key / foreign key data—used for data models.
– The Relationship connector—Used between
two tables, and incorporates primary key /
foreign key data—used for database designs.
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-22
Copying Database Model Diagram Files
• Make two copies of the existing Microsoft
Visio 2010 drawing for use when building
the data model and database design.
There are now three versions of the file:
– The original WPC-Database-Model-Tables.vsd file—
This file is our basic working file with only the tables in
it.
– The WPC-Database-Design.vsd file—This file will be
used for our WPC database design.
– The WPC-Data-Model.vsd file—This file will be used
for our WPC data model.
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-23
The Dynamic Connector
Attached to the EMPLOYEE Table
Figure G-16: The Dynamic Connector Attached to the EMPLOYEE Table
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-24
The Dynamic Connector Attached
to Both the EMPLOYEE and DEPARTMENT Tables
Figure G-17:
The Dynamic Connector Attached to Both the EMPLOYEE and DEPARTMENT Tables
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-25
The Dynamic Connector Adjusts as the
DEPARTMENT Table Is Moved
Figure G-18:
The Dynamic Connector Adjusts as DEPARTMENT Table is Moved
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-26
The Dynamic Connector as a Line
Figure G-19: The Dynamic Connector as a Line
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-27
The Short-cut Menu
Figure G-20: The Short-Cut Menu
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-28
The Line Dialog Box
Figure G-21: The Line Dialog Box
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-29
Available Line Ends
“Begin” End
Figure G-22: Available Line Ends – “Begin” End
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-30
The Formatted
Dynamic Connector Line
Figure G-23: The Formatted Dynamic Connector Line
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-31
The N:M Relationship
in the Data Model
Figure G-24: The N:M Relationship in the Data Model
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-32
The Relationship Connector in the
Database Design
Figure G-25: The Relationship Connector in the Database Design
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-33
The Attached Relationship
Connector in the Database Design
Figure G-26:
The Attached Relationship Connector in the Database Design
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-34
The Relationship Connector Dynamically
Adjusts When EMPLOYEE Table is Moved
Figure G-27:
The Relationship Connector Dynamically Adjusts When EMPLOYEE Table is Moved
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-35
Editing the EMPLOYEE Table Columns
Figure G-28: Editing the EMPLOYEE Table Columns
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-36
The Edited the EMPLOYEE Table Columns
Figure G-29: The Edited EMPLOYEE Table Columns
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-37
The Categories Miscellaneous Page
Figure G-30: The Categories Miscellaneous Page
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-38
Microsoft Visio 2010 Cardinalities
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-39
The Categories Referential Action Page
Figure G-31: The Categories Referential Action Page
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-40
The Completed
1:N Nonidentifying Relationships
Figure G-32: The Completed 1:N Nonidentifying Relationships
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-41
The E-R Database Design with an
Intersection Table
Figure G-33: The E-R Database Design with an Intersection Table
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-42
The E-R Database Design with an
Association Table
Figure G-34: The E-R Database Design with an Association Table
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-43
The Database Command Tab and
Database Command Groups
Figure G-35: The Database Command Tab and Database Command Groups
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-44
The Database Document Options
Dialog Box—General Tab
Figure G-36: The Database Document Options Dialog Box—General Tab
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-45
The Database Document Options
Dialog Box—Relationship Tab
Figure G-37: The Database Document Options Dialog Box—Relationship Tab
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-46
The WPC Database Design with IE
Crow’s Foot Notation
Figure G-38: The WPC Database Design with IE Crow’s Foot Notation
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-47
Business Processing Modeling Notation
(BPMN) in Microsoft Visio 2010
• See the Microsoft Visio Insights blog at
http://blogs.msdn.com/b/visio/archive/2009/12/03/bpmn-support-invisio-2010.aspx for a good discussion of BPNM in Microsoft Visio
2010.
• Unfortunately, full BPMN support is only available in the Visio
Premium edition (see http://office.microsoft.com/en-us/visio/visioedition-comparison-FX101838162.aspx ).
• For more information on BPMN, see the Object Management
Group’s Business Process Management Initiative Web page at
http://www.bpmn.org/.
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
G-48
DAVID M. KROENKE and DAVID J. AUER
DATABASE CONCEPTS, 6th Edition
End of Presentation on Appendix G
Getting Started with
Microsoft Visio 2010