Home Page Icon
Home Page
Table of Contents for
Exercise 9.1: Creating a Logical Relational Data Model in ER/Studio
Close
Exercise 9.1: Creating a Logical Relational Data Model in ER/Studio
by Steve Hoberman
Data Modeling Made Simple with ER/Studio Data Architect
Contents at a Glance
Contents
Read me first!
Conventions Used in this Book
How to get the Most out of this Book
Section I: Overview
Chapter 1: Data Model Overview
Finding Your Way
Representing an Information Landscape
Leveraging the Data Model
Embarking on Our Publishing Adventure
Exercise 1.1: Educating Your Neighbor
Chapter 2: ER/Studio Functionality
Exercise 2.1: Learning More About the ER/Studio XE3 Family
New Features
My “Top 10” Favorite Features of ER/Studio
Exercise 2.2: Installing and Starting ER/Studio
Chapter 3: ER/Studio Landscape
Using the Windows
Data Model Explorer
Data Model Window
Overview Window
Zoom Window
Using the Menus
Application Menus
Shortcut Menus
Using the Toolbars
Using Keyboard Commands
Using the Status Bar
Exercise 3.1: Creating a New Data Model
Creating Title Blocks
Editing Title Blocks
Deleting Title Blocks
Exercise 3.2: Saving Your Data Model
Exercise 3.3: Closing and Opening Existing Data Models
Exercise 3.4: Getting Comfortable with ER/Studio
Section II: Data Model Objects
Chapter 4: Entities
Entity Explanation
Entity Types
Entities in ER/Studio
Creating Entities
Editing Entities
Moving Entities
Resizing Entities
Changing the Appearance of Entities
Copying Entities
Finding Entities
Deleting Entities
Exercise 4.1: Creating Entities in ER/Studio
Chapter 5: Submodels
Submodel Explanation
Submodels in ER/Studio
Creating Submodels
Editing Submodels
Moving Submodels
Deleting Submodels
Exercise 5.1: Changing Settings in Submodels
Exercise 5.2: Creating Three More Submodels
Exercise 5.3: Creating Title Blocks for each Submodel
Chapter 6: Attributes and Domains
Attribute Explanation
Attribute Types
Attributes in ER/Studio
Creating Attributes
Editing Attributes
Moving Attributes
Defining Attributes
Changing the Appearance of Attributes
Copying Attributes
Finding Attributes
Deleting Attributes
Exercise 6.1: Creating Attributes in ER/Studio
Key Explanation
Candidate Key
Primary and Alternate Keys
Surrogate Key
Foreign Key
Inversion Entry
Exercise 6.2: Clarifying Customer ID
Keys in ER/Studio
Creating a Key
Editing a Key
Exercise 6.3: Creating Keys in ER/Studio
Domain Explanation
Domains in ER/Studio
Chapter 7: Relationships
Relationship Explanation
Relationship Types
Cardinality
Independent vs. Dependent Entities
Recursion
Subtyping
Exercise 7.1: Reading a Model
Data Modeling Notations
Relationships in ER/Studio
Creating Relationships
Creating Subtypes
Creating Recursive Relationships
Editing Relationships
Moving Relationships
Changing the Appearance of Relationships
Finding Relationships
Deleting Relationships
Exercise 7.2: Creating Relationships in ER/Studio
Section III: Conceptual, Logical, and Physical Data Models
Chapter 8: Conceptual Data Models
Conceptual Data Model Explanation
Relational and Dimensional Conceptual Data Models
Relational CDM Example
Dimensional CDM Example
Creating a Conceptual Data Model
Exercise 8.1: Creating a Conceptual Data Models in ER/Studio
Exercise 8.3: Segmenting the Publisher CDM into Submodels
Exercise 8.4: Creating a Conceptual Data Model for Your Organization
Chapter 9: Logical Data Models
Logical Data Model Explanation
Relational and Dimensional Logical Data Models
Relational LDM Example
Dimensional LDM Example
Creating a Relational Logical Data Model
Normalization
Abstraction
Exercise 9.1: Creating a Logical Relational Data Model in ER/Studio
Creating a Dimensional Logical Data Model
Chapter 10: Physical Data Models
Physical Data Model Explanation
Relational and Dimensional Physical Data Models
Relational PDM Example
Dimensional PDM Example
Creating a Physical Data Model in ER/Studio
Generating a Physical Data Model from a Logical Data Model
Generating a Physical Data Model from a Database (Reverse Engineering)
Generating a Physical Data Model from a SQL File
Editing Tables
Customizing Datatype Mapping
Denormalization
Rolldown Denormalization
Rollup Denormalization
Star Schema
Denormalizing in ER/Studio
Exercise 10.1: Denormalizing in ER/Studio
Views
Views in ER/Studio
Exercise 10.2: Creating Views in ER/Studio
Indexing
Indexing in ER/Studio
Exercise 10.3: Indexing in ER/Studio
Partitioning
Partitioning in ER/Studio
Exercise 10.4: Partitioning in ER/Studio
Exercise 10.5: Tracing from Physical back to Logical
Section IV: Additional ER/Studio Features
Chapter 11: Data Dictionary
Importing a Data Dictionary
Types of Objects Imported from a Data Dictionary
Domains
Domains in ER/Studio
Exercise 11.1: Creating Domains in ER/Studio
User-Defined Datatypes
User-Defined Datatypes in ER/Studio
Exercise 11.2: Creating User-Defined Datatypes in ER/Studio
Reference Values
Reference Values in ER/Studio
Exercise 11.3: Creating Reference Values in ER/Studio
Attachments
Attachments in ER/Studio
Exercise 11.4: Creating Attachments in ER/Studio
Chapter 12: Data Lineage
Using the Data Lineage Tab
Defining Source Systems in ER/Studio
Creating Data Movement Rules in ER/Studio
Creating a Data Flow in ER/Studio
Using the Table Editor to Further Document Lineage
Using the Column Editor to Further Document Lineage
Exercise 12.1: Creating a Data Lineage
Chapter 13: Macros
Running Macros
Top 5 Favorite Macros
Creating Macros
Editing Macros
Deleting Macros
Renaming Macros
Exercise 13.1: Creating and Running Macros
Chapter 14: Importing, Exporting, Printing, and Reporting
Importing into ER/Studio
Exporting out of ER/Studio
Exporting to External Metadata
Exporting to XML
Exporting to a SQL file
Exporting an Image
Printing in ER/Studio
Reporting in ER/Studio
Exercise 14.1: Importing, Exporting, Printing, and Reporting
Chapter 15: Naming Standards
Creating a Naming Standards Template
Applying the Naming Standards Utility
Assigning Naming Standards to Objects
Exercise 15.1: Creating a Naming Standard Template in ER/Studio
Chapter 16: Compare/Merge Utility
Comparing Models and Submodels in ER/Studio
Exercise 16.1: Running the Compare and Merge Utility in ER/Studio
Appendix A: References
Appendix B: Answers to Exercises
Exercise 1.1: Educating Your Neighbor
Exercise 5.1: Changing Settings in Submodels
Exercise 6.2: Clarifying Customer ID
Exercise 7.1: Reading a Model
Exercise 8.1: Creating a Conceptual Data Model in ER/Studio
Exercise 9.1: Creating a Logical Relational Data Model in ER/Studio
Appendix C: Glossary
Appendix D: ERStudio Commands Quick Reference
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Exercise 8.1: Creating a Conceptual Data Model in ER/Studio
Next
Next Chapter
Appendix C: Glossary
EXERCISE 9.1: Creating a Logical Relational Data Model
in
ER/Studio
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset