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

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 3.2 is not applied since the source program and target program are in the same
platform.
Step 3.3. Upload database.
The unloaded sequential files are loaded to a relational database based on the
translated relational schema. The translated relational schema will include one cre-
ate statement for each relation. The following are the create statements for the re-
lational schema.
&5($7(7$%/(+263,7$/

+2631$0( &+$5 12718//

+263+21( &+$5 12718//

$'0,1725 &+$5 12718//

35,0$5<.(<+2631$0(

&5($7(7$%/(:$5'

+2631$0( &+$5 12718//

:$5'12 &+$5 2718//

72752206 &+$5 12718//

727%('6 &+$5 12718//

%('$9$,/ &+$5 12718//

:$57<3( &+$5 12718//

35,0$5<.(<:$5'12
)25(,*1.(<+2631$0(

&5($7(7$%/(3$7,(17

:$5'12 &+$5 12718//

3$71$0( &+$5 12718//

3$73+21( &+$5 12718//

%(','(17 &+$5 12718//

'$7($'07 &+$5 12718//

35,0$5<.(<%(','(17
)25(,*1.(<:$5'12