
Application for Request about reservation:
Fragmentation Transparency (Level 1):
read (PNO, RFNO);
Select TOTALSEAT into $TOTALSEAT from FLIGHT where FNO = RFNO;
If $TOTALSEAT > 0 then [if seats are available]
Select NAME, ADDRESS, PHONENO into $NAME, $ADDRESS, $PHONENO from PASSENGER where
PCODE = PNO;
insert into RESERVATION (PCODE, FNO, SEATNO) values (PCODE, FNO, $SEATNO);
if not FOUND then
read (NPCODE, NNAME, NADDRESS, NPHONENO);
insert into PASSENGER(PCODE, NAME, ADDRESS, PHONENO) values
(NPCODE, ‘NNAME’, ‘NADDRESS’, ‘NPHONENO’);
insert into RESERVATION (PCODE, FNO, SEATNO) values (NPCODE, RFNO, $SEATNO);
Location Transparency (Level 2):
read (PNO, ...