|
|
|
CA 2E has two types of relations, file-to-file relations and file-to-field relations, which together consist of eight relation types. To define a relation you must use one of these eight relation types, described later in this topic.
You use CA 2E relations to declare the existence of a file and to describe the connection between files or between a file and a field. The relations you enter for a file are resolved into the fields that are needed to implement that file. Because a file consists of a list of relations, to completely define a file, you must enter all the relations that describe that file.
The Has, Known by, Owned by, and Refers to are CA 2E basic relations that cover most data modeling cases. CA 2E automatically creates Defined as relations for each of the files you define.
CA 2E also resolves a primary key based on the relation types that you enter for a file. It requires a unique key for all database files, which should be the smallest set of fields needed.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |