How many files are needed and what will their structure
be? A nursery membership file might have the following
structure:
| Field |
Type |
Length |
Example |
| Membership No. |
Numeric |
6 |
352600 |
| Surname |
Text |
20 |
McSweeney |
| First Name |
Text |
15 |
Jane |
| Address line 1 |
Text |
25 |
3 Longlane |
| Address line 2 |
Text |
25 |
London |
| Post Code |
Alpha numeric |
10 |
N1 1TH |
| Telephone No. |
Alpha numeric |
10 |
0181-366-1234 |
| Fees Paid |
Text |
1 |
Y |
| Fee Date |
Date |
8 |
22/04/97 |
|
