高教版数据库系统概论（王珊）实验报告全集

create table stu( num int not null unique, name char(20) not null, sex int, age int, dept char(8)); create table cou( num int not null unique, name char(20) not null, credit int); create table s_c( s_num int not null, c_num int not null, grade int); create or replace procedure insert_stu() as declare sexflag int; age int; dept char(8); begin for i in 1..9850 loop if i%4 = 0 then age = 17; elsif i%4 = 1 then age = 18; elsif i%4 = 2 then age = 19; else age = 20; end if; if i%2 = 0 then sexflag = 0; else sexflag = 1; end if; if i%3 = 0 then dept = 'CS'; elsif i%3 = 1 then dept = 'IS'; else dept = 'MA'; end if; insert into stu values(i, 'Name' || i, sexflag, age, dept); end loop; for j in 9851..10000 loop if j%2 = 0 then sexflag = 0; age = 21; else sexflag = 1; age = 22; end if; dept = 'CS'; insert into stu values(j, 'Name' || j, sexflag, age, dept); end loop; end; create or replace procedure insert_cou() as begin for i in 1..100 loop insert into cou values(i, 'Name' || i, i%5); end loop; end; create or replace procedure insert_s_c() as begin for i in 1..10000 loop for j in 1..100 loop insert into s_c values(i,j,(i*j)%100); end loop; end loop; end;