Database Management System Emulation - Information Systems Reengineering, Integration and Normalization - page 234

Next, we create template files from the hierarchical schema in order to store the
parent-child segments' linkages and their attributes in a working file for later pro-
cessing. The segment template file is as follows:

Logicalsegment Physicaldatabase Physicalsegment Parentsegment Segmentfield

HOSPITAL HOSPITAL HOSPITAL 0 HOSPNAME

WARD HOSPITAL WARD HOSPITAL WARDNO

PATIENT HOSPITAL PATIENT WARD BEDIDENT

SYMPTOM HOSPITAL SYMPTOM PATIENT SYMPDATE

TREATMNT HOSPITAL TREATMNT PATIENT TRDATE

FACILITY HOSPITAL FACILITY HOSPITAL

Hierarchical
level

Segmentnumber Segmentlength Segmenttype Number

of fields

Cumulative
key length

000 000 050 F 003 020

001 001 031 F 005 022

002 002 040 F 004 026

003 003 047 P 004 032

003 004 046 P 003 032

001 005 031 I 003 020

Create Field template file as follows:

Seg. No. Field No. Field name Field

type

Start
byte

Field
length

Key
flag

Target
length

Decim
places

000 001 hospname C 001 020 U 020 000

000 002 hosphone C 021 010 N 010 000

000 003 admintor C 031 020 N 020 000

001 001 wardno C 001 002 U 002 000

001 002 totrooms F 003 004 N 008 000

001 003 totbeds H 007 002 N 004 000

001 004 bedavail C 009 003 N 003 000

001 005 wardtype C 012 020 N 020 000

002 001 patname C 001 020 N 020 000

002 002 patphone C 021 010 N 010 000

002 003 bedident C 031 004 U 004 000

002 004 dateadmt C 035 006 N 006 000

003 001 diagnose C 001 020 N 020 000

003 002 sympdate C 021 006 Y 006 000

003 003 prevtrea C 027 001 N 001 000

003 004 treadesc C 028 020 N 020 000

004 001 trtype C 001 020 N 020 000