HP Integrity NonStop J-Series - Manual (Page 59)

DEVELOPING A DATA BASE
Listing the Fields in Each File
Dependents Employee
Many One
Figure 3-7. One-to-Many Relationship
Listing the Fields in Each File
At this point, you have identified the two files in the personnel
data base: employee and dependents. Since dependents is too
long to be a valid file name (eight character maximum length),
you might shorten this name to "depend." The next step is to
list the fields in each file as shown in Figure 3-8.
-----------------------------------------------------------------
| |
| EMPLOYEE empnum, empname, regnum, branchnum, job, age, |
| salary, vacation |
| |
| DEPEND emp-no, dependent-name, relationship, dependent-age |
| |
-----------------------------------------------------------------
Figure 3-8. List of Fields in Both Files
Notice that both files contain a field that represents an
employee identification number. The presence of such duplicate
fields is essential because you need these fields to provide
logical connections when you use ENABLE to generate an
application or use ENFORM to request a report.
After you list the fields in each file, you are ready to select
the physical structure for the file.
3-8