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); |