4.3.11.2 More Efficient Example
Physical file PSLMST (personnel master file) has the following fields and an additional logical view called PSLMSTV1 keyed by SURNAME:
Field | Type | Length | Description |
|---|---|---|---|
EMPNO | S | 5 | Employee number (primary key) |
GIVENAME | A | 20 | Given name |
SURNAME | A | 20 | Surname |
ADDRESS1 | A | 30 | Address line 1 |
ADDRESS2 | A | 30 | Address line 2 |
ADDRESS3 | A | 30 | Address line 3 |