create table tape (
tpnumb number(4,0) constraint tape_not_null not null
constraint tape_pk primary key check (tpnumb > 0),
mvnumb number(4,0) constraint tape_mvnumb_not_null not null,
purdate date constraint purdate_not_null not null,
tmsrent number(3,0) constraint tmsrent_not_null not null,
mmbnumb number(4,0),
foreign key (mvnumb) references movie,
foreign key (mmbnumb) references member);

prompt Created table tape.;


insert into tape values
(1, 1, to_date('04,26,94','mm/dd/yy'),4, null);
insert into tape values
(2,2,to_date('04,26,94','mm/dd/yy'),4,2);
insert into tape values
(3,3,to_date('04,26,94','mm/dd/yy'),6,null);
insert into tape values
(4,4,to_date('04,28,94','mm/dd/yy'),8,10);
insert into tape values
(5,5,to_date('05,12,94','mm/dd/yy'),3,4);
insert into tape values
(6,6,to_date('05,12,94','mm/dd/yy'),8,null);
insert into tape values
(7,7,to_date('05,12,94','mm/dd/yy'), 2,2);
insert into tape values
(8,8,to_date('05,12,94','mm/dd/yy'), 9,8);
insert into tape values
(9,6,to_date('06,26,94','mm/dd/yy'), 1,null);
insert into tape values
(10,9,to_date('06,26,94','mm/dd/yy'),7,3);
insert into tape values
(11,10,to_date('06,26,94','mm/dd/yy'),10,null);
insert into tape values
(12,11,to_date('07,11,94','mm/dd/yy'), 6,6);
insert into tape values
(13,12,to_date('08,02,94','mm/dd/yy'), 4, null);
insert into tape values
(14,6,to_date('08,02,94','mm/dd/yy'), 5, null);
insert into tape values
(15,13,to_date('08,25,94','mm/dd/yy'),2,2);
insert into tape values
(16,14,to_date('08,25,94','mm/dd/yy'),7, null);
insert into tape values
(17,15,to_date('09,07,94','mm/dd/yy'), 11,null);
insert into tape values
(18,16,to_date('09,07,94','mm/dd/yy'),6,8);
insert into tape values
(19,17,to_date('09,23,94','mm/dd/yy'),3,null);
insert into tape values
(20,14,to_date('10,12,94','mm/dd/yy'), 4,3);
insert into tape values
(21,18,to_date('11,15,94','mm/dd/yy'),8,null);
insert into tape values
(22,19,to_date('11,15,94','mm/dd/yy'),3,null);
insert into tape values
(23,20,to_date('12,21,94','mm/dd/yy'),4,null);
insert into tape values
(24,21,to_date('01,11,95','mm/dd/yy'),9,7);
insert into tape values
(25,22,to_date('02,14,95','mm/dd/yy'),2, null);
insert into tape values
(26,23,to_date('02,14,95','mm/dd/yy'),1,null);
insert into tape values
(27,24,to_date('03,06,95','mm/dd/yy'),4,3);