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

* BEDIDENT DIAGNOSE SYMPDATE PREVTREA TREADESC

0009 BLEEDING 860601 N

0009 FAINT 860602 N

0001 BROKEN LEG 860720 N

Segment TREATMNT

BEDIDENT TRTYPE TRDATE MEDITYPE

0003 CHEST PAIN 860823 HEART DRUG

0008 REST 860714 NIL

0004 REST 860514 ZANTAC

0009 BANDAGE 860602 NIL

0009 REST 860603 INFLUENZA

0001 LEG SURGE 860721 NIL

Segment FACILITY

* HOSPNAME SEQUENCE# FACTYPE TOTFACIL FACAVAIL

MAC NEAL 000001 CARDIOGRAPHIC M/C 10 9

MAC NEAL 000002 X-RAY M/C 3 3

MAC NEAL 000003 OXYGEN SUPPLY 90 81

RIVEREDGE 000001 CARDIOGRAPHIC M/C 10 9

RIVEREDGE 000002 X-RAY M/C 3 3

RIVEREDGE 000003 OXYGEN SUPPLY 90 81

Step 2.3.Translate embedded SQL into a hierarchical database program.
Each embedded SQL program is then translated into a hierarchical database pro-
gram. In this case study, an embedded SQL program for deleting ward data and/or
updating a patient phone number can be translated into an information-capacity-
equivalent hierarchical database program as follows: