
if not FOUND then
read (nviewer-id, nname, naddress, nphone-number);
insert into VIEWER
2
AT SITE 2 (viewer-id, name, address, phone-number) values
(nviewer-id, ‘nname’, ‘naddress’, ‘nphone-number’);
insert into RESERVATION
2
AT SITE 2 (viewer-id, show-id, seat-no) values
(nviewer-id, $show-id, $seat-no);
if not FOUND then
Select totalseat, rseat into $totalseat, $rseat from SHOW
3
AT SITE 3 where show-id = $show-id;
If ($totalseat - $rseat) > 0 then [if seats are available]
Select name, address, phone-number into $name, $address, $phone-number from VIEWER
3
AT SITE 3 where
viewer-id = $viewer-id;
insert into RESERVATION
3
AT SITE 3 (viewer-id, show-id, seat-no) ...