WIXLIB

CA ERwin Data ModelerNavigator EditionUser GuideRelease 9.64.01

Thi s Documentation, which i ncludes embedded help systems a nd electronically distributed materials (hereinafter referred to asthe “Documentation”), is for your informational purposes only a nd is s ubject to change or withdrawal by CA a t a ny ti me. ThisDocumentation is proprietary i nformation of CA a nd may not be copied, tra nsferred, reproduced, disclosed, modified orduplicated, in whole or i n part, without the prior wri tten consent of CA.If you a re a licensed user of the software product(s) addressed in the Documentation, you may pri nt or otherwise makea va ilable a reasonable number of copies of the Documentation for internal use by you a nd your employees i n connection withtha t s oftware, provided that all CA copyri ght notices and legends a re affixed to each reproduced copy.The ri ght to print or otherwise make a vailable copies of the Documentation is limited to the period during which the applicablel i cense for s uch software remains i n full force a nd effect. Should the license terminate for a ny reason, i t is your responsibility tocerti fy i n writing to CA tha t all copies and partial copies of the Documentation have been returned to CA or destroyed.TO THE EXTENT PERMITTED BY APPLICABLE LAW, CA PROVIDES THIS DOCUMENTATION “AS IS” WITHOUT WARRANTY OF ANYKIND, INCLUDING WITHOUT LIMITATION, ANY IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULARPURPOSE, OR NONINFRINGEMENT. IN NO EVENT WILL CA BE LIABLE TO YOU OR ANY THIRD PARTY FOR AN Y LOSS OR DAMAGE,DIRECT OR INDIRECT, FROM THE USE OF THIS DOCUMENTATION, INCLUDING WITHOUT LIMITATION, LOST PROFITS, LOSTINVESTMENT, BUSINESS INTERRUPTION, GOODWILL, OR LOST DATA, EVEN IF CA IS EXPRESSLY ADVISED IN ADVANCE OF THEPOSSIBILITY OF SUCH LOSS OR DAMAGE.The us e of any s oftware product referenced i n the Documentation is governed by the a pplicable license a greement a nd s uchl i cense agreement is not modified in a ny wa y by the terms of this notice.The ma nufacturer of this Documentation is CA.Provi ded wi th “Restricted Rights.” Use, duplication or disclosure by the United States Government is subject to the restricti onss et forth in FAR Sections 12.212, 52.227-14, a nd 52.227-19(c)(1) - (2) a nd DFARS Section 252.227-7014(b)(3), as applicable, orthei r s uccessors.Copyri ght 2016 CA. Al l ri ghts reserved. All tra demarks, tra de names, servi ce marks, a nd l ogos referenced herein belong tothei r respective companies.

CA Technologies Product ReferencesThis document references the following CA Technologies products: CA ERwin Data Modeler Navigator Edition CA ERwin Data Modeler Standard Edition CA ERwin Data Modeler Workgroup Edition

Contact CA TechnologiesUnderstanding your SupportReview support maintenance programs and offerings .Registering for SupportAccess the CA Support online registration site to register for product support.Accessing Technical SupportFor your convenience, CA Technologies provides easy access to "One Stop" support forall editions of CA ERwin Data Modeler, and includes the following: Online and telephone contact information for technical assistance and customerservices Information about user communities and forums Product and documentation downloads CA Support policies and guidelines Other helpful resources appropriate for your productFor information about other Home Office, Small Business, and Enterprise CATechnologies products, visit http://ca.com/support.Provide FeedbackIf you have comments or questions about CA Technologies product documentation, yo ucan send a message to techpubs@ca.com.If you would like to provide feedback about CA Technologies product documentation,complete our short customer survey, which is also available on the CA Support website,found at http://ca.com/docs.CA ERwin Data Modeler News and EventsVisit www.erwin.com to get up-to-date news, announcements, and events. View videodemos and read up on customer success stories and articles by industry experts.

ContentsChapter 1: Working with CA ERwin Data Modeler Navigator Edition7Intended Audience. 7CA ERwin Data Modeler Navigator Edition. 8Modeling Overview. 8The Application Development Cycle. 9Chapter 2: Installation11Install CA ERwin Data Modeler Navigator Edition. 11Uninstall the Navigator Edition. 12Post-Installation. 12Install the SSL Certificate . 13Chapter 3: Navigating Data Models15Data Models . 15Basic Data Modeling Concepts . 15Model Types . 16Entities. 17Tables . 18Attributes and Columns . 19Primary Key and Non-Keys . 20Relationships . 21Foreign Key . 23Workplace Panes. 24Overview of Model Explorer . 26Action Log . 31Advisories Pane . 39Overview Pane . 39Bulk Editor Pane . 40Open an Existing Model . 41Open a Model Saved in XML Format (XML Import) . 41Connect to Mart . 42Open a Model or Submodel from the Mart . 43Customizing the Appearance of Data Models. 45Display Levels . 45Font and Color Change for Individual Objects . 49Changing the Diagram Window Magnification Level . 51Contents 5

Print a Data Model . 52Print Only What You Want . 53Set Printer Options. 53Specify an Exact Print Scale Value. 54Add a Page Header or Footer . 54Page Margins. 55Page Boundaries . 56Set Print Margins . 56Chapter 4: Reporting57Data Model Reporting . 57The Query Tool . 57Appendix A: Product Differences63CA ERwin Data Modeler Navigator Edition Differences . 63Data Model Disabled Menu Items and Toolbar Icons . 64Index6 User Guide65

Chapter 1: Working with CA ERwin DataModeler Navigator EditionThis section contains the following topics:Intended Audience (see page 7)CA ERwin Data Modeler Navigator Edition (see page 8)Modeling Overview (see page 8)The Application Development Cycle (see page 9)Intended AudienceThis guide is intended for use by individuals such as business or system analysts,database designers, and programmers who require read-only access to models createdin CA ERwin Data Modeler. You can use CA ERwin Data Modeler Navigator Edition toview, print, and manipulate models. The only limitation is that you cannot save any typeof model change, including any made to models accessed in a mart database.You can use this product on data models that are on a local drive, network drive, or in amart database to: View the work of others while it is in progress. Provide input without inadvertently changing work. Read the information in a model in order to create queries, reports, or applications.If you are already familiar with CA ERwin Data Modeler, CA ERwin Data ModelerNavigator Edition offers most of the features currently available in the full -featureversion of these products.Note: For more information about product differences, see CA ERwin Data ModelerNavigator Edition Differences (see page 63).To use this product with data models, you should have a working knowledge ofdatabase management, entity-relationship diagrams, and IDEF1X and IE data modelingterms. If you are using a data warehousing environment, you should also have a workingknowledge of dimensional modeling terms.Chapter 1: Working with CA ERwin Data Modeler Navigator Edition 7

CA ERwin Data Modeler Navigator EditionCA ERwin Data Modeler Navigator EditionCA ERwin Data Modeler Navigator Edition is one of the editions of CA ERwin DataModeler. These editions provide a foundation for building, deploying, and managingapplications. These editions consist of project management, change and configurationmanagement, modeling and design, and knowledge publication and visualization. Theystre

This Documentation, which includes embedded help systems and electronically distributed materials (hereinafter referred to as the “Documentation”), is for your informational purposes only and is subject to change or withdrawal by CA at any time.