Advantage 2E 8.0 Tutorial

Computer Associates

Sujets

• Horses (album)
• Relations entre le bouddhisme et les autres religions
• Mouvement socialiste panhellénique
• How to Save a Life
• Application linéaire
• Damas

Informations

• Publié par: Ummo
• Nombre de lectures: 115
• Langue: English
• Poids de l'ouvrage: 6 Mo

Extrait

™Advantage 2E Tutorial 8.0  This documentation and related computer software program (hereinafter referred to as the “Documentation”) is for the end user’s informational purposes only and is subject to change or withdrawal by Computer Associates International, Inc. (“CA”) at any time. This documentation may not be copied, transferred, reproduced, disclosed or duplicated, in whole or in part, without the prior written consent of CA. This documentation is proprietary information of CA and protected by the copyright laws of the United States and international treaties. Notwithstanding the foregoing, licensed users may print a reasonable number of copies of this documentation for their own internal use, provided that all CA copyright notices and legends are affixed to each reproduced copy. Only authorized employees, consultants, or agents of the user who are bound by the confidentiality provisions of the license for the software are permitted to have access to such copies. This right to print copies is limited to the period during which the license for the product remains in full force and effect. Should the license terminate for any reason, it shall be the user’s responsibility to return to CA the reproduced copies or to certify to CA that same have been destroyed. To the extent permitted by applicable law, CA provides this documentation “as is” without warranty of any kind, including without limitation, any implied warranties of merchantability, fitness for a particular purpose or noninfringement. In no event will CA be liable to the end user or any third party for any loss or damage, direct or indirect, from the use of this documentation, including without limitation, lost profits, business interruption, goodwill, or lost data, even if CA is expressly advised of such loss or damage. The use of any product referenced in this documentation and this documentation is governed by the end user’s applicable license agreement. The manufacturer of this documentation is Computer Associates International, Inc. Provided with “Restricted Rights” as set forth in 48 C.F.R. Section 12.212, 48 C.F.R. Sections 52.227-19(c)(1) and (2) or DFARS Section 252.227-7013(c)(1)(ii) or applicable successor provisions.  2002 Computer Associates International, Inc. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.  Contents Chapter 1: About this Tutorial Introduction.................................................................................. 1-1 Chapter 2 Requirements ................................................................... 1-1 Chapter 3 Data Modeling .................................................................. 1-1 Chapter 4 Designing Functions ............................................................. 1-2 Chapter 5 Generating, Compiling and Executing ............................................. 1-2 Chapter 6 Maintaining Your Application .................................................... 1-2 Chapter 7 Advanced Functions 1-2 Chapter 8 Report Functions ................................................................ 1-2 Related Information........................................................................... 1-2 Overview................................................................................. 1-3 Getting Started............................................................................ 1-3 Defining a Data Model..................................................................... 1-3 Building Access Paths 1-3 Building Applications 1-3 Generating and Implementing Applications ................................................. 1-3 Advantage 2E and the Application Development Life Cycle....................................... 1-4 Prerequisites for Using Advantage 2E........................................................... 1-5 Chapter 2: Defining Requirements Introduction to Defining Requirements ......................................................... 2-1 Requirements Definition................................................................... 2-1 Chapter 3: Data Modeling Data Model................................................................................... 3-1 Objectives ................................................................................ 3-2 Identify Application Entities ............................................................... 3-2 Identify Business Relationships Between Entities............................................. 3-2 Contents iii  Identify Attributes and Unique Identifiers for the Entities......................................3-3 Identify the Attributes for Each Entity .......................................................3-3 Select Each Entity’s Unique Identifier........................................................3-4 Normalize the Entities......................................................................3-7 Generalizties .....................................................................3-8 Advantage 2E Data Model Diagram .........................................................3-9 Advantage 2E Relations ...................................................................3-10 Objectives................................................................................3-10 Overview of Advantage 2E Relations3-10 The Edit Database Relations Panel..........................................................3-11 Entering Relation Statements ..............................................................3-12 Validation of Relation Statements3-13 Defining Objects..........................................................................3-14 Specifying Object Attributes ...............................................................3-15 File Entries...............................................................................3-16 File Entries for COURSE...................................................................3-16 File Entries for RACE .....................................................................3-18 Adding More Relations....................................................................3-19 Declaring More Files......................................................................3-19 Defining Objects3-20 File Attributes............................................................................3-20 Deleting Relations ........................................................................3-21 Documenting Relations3-21 Field Details and Conditions3-22 Objectives................................................................................3-22 Overview of Field Details..................................................................3-22 f Field Conditions..............................................................3-22 Field Details..............................................................................3-23 ail Display for Horse Gender ......................................................3-23 Field Conditions..........................................................................3-24 Adding a Field Condition .................................................................3-24 Field Condition Details....................................................................3-26 Adding Field Condition Detail.............................................................3-26 Adding Another Condition................................................................3-26 Viewing Field Conditions3-27 Specifying a Check Condition3-28 Exercises.................................................................................3-29 Displaying Selected Relations..............................................................3-29 Extending Relations ..........................................................................3-31 Objectives................................................................................3-31 Overview of Relation Extension............................................................3-32 iv Tutorial  Involution and the Horse Pedigrees........................................................ 3-32 Adding More Relations ................................................................... 3-33 Sequence of Relations..................................................................... 3-33 Extending Relations ...................................................................... 3-34 Extended Relations for HORSE File 3-35 Example Showing Use of the Sharing Field ................................................. 3-36 Adding Details of Extended Relations...................................................... 3-36 Field Entries for HORSE .................................................................. 3-36 Assigning Unique Names to Field Entries .................................................. 3-38 Showing and Hiding Relation Extension Lines .............................................. 3-38 Virtual Fields................................................................................ 3-38 Overview of Virtual Fields ................................................................ 3-39 Specifying Virtual Fields 3-39 Virtual Fields for Details of a Horse’s Dam and Sire ......................................... 3-40 Sequence of Relations and Virtual Fields.................................................... 3-40 Adding Virtual Fields .................................................................... 3-41 Virtual Field Entries ...................................................................... 3-41 Selecting Virtual Fields for Dam ........................................................... 3-41 Confirming Virtual Fields for Dam......................................................... 3-42 Adding More Virtual Fields ............................................................... 3-42 Selecting Virtual Fields for Sire ...................