create table apsent(
apid number (5) constraint ap_id primary key,
stid number (5) references student(stid),
coid number (5) references corse( coid),
apdate date)
/
