insert into stu_info values (2012341403,'sl','M',13800198010,'1988981986060
91785','HBSCDDYZX','HBSCDSFPL78H');

insert into stu_info values (2012341404,'zq','M',16310137108,'3166111988011
73309','HBSCDDYZX','HBSCDDYZX');

insert into stu_info values (2012341405,'sz','F',13010013875,'10177519871204
1124','HBSLHDYZX','HBSLHDYZX');

insert into stu_info values (2012341406,'bf','M',13810131100,'130822198604
071701','HBSJZDYZX','HBSLHXFYL8H');

insert into stu_info values (2012341407,'zh','F',19999999999,'999999198909
29999Y','HBSLHDYZX','HBSLHDYZX');

2.建立学生志愿表（stu_wish）

create table stu_wish (

stu_num number(10) primary key,

fir_university_id number(5) not null,

sec_university_id number(5)

);

insert into stu_wish values (2012100201,10001,20002);

insert into stu_wish values (2012100202,10003,20002);

insert into stu_wish values (2012100203,10004,20001);

insert into stu_wish values (2012100204,10004,20005);

insert into stu_wish values (2012100205,10005,20001);

insert into stu_wish values (2012100206,10002,20005);

insert into stu_wish values (2012100207,10003,20003);

insert into stu_wish values (2012100208,10001,20004);

insert into stu_wish values (2012100209,10002,20004);

insert into stu_wish values (2012100210,10005,20002);

insert into stu_wish values (2012100211,10002,20003);

insert into stu_wish values (2012100212,10003,20002);

insert into stu_wish values (2012211101,10011,20011);

insert into stu_wish values (2012211102,10012,20015);

insert into stu_wish values (2012211103,10014,20014);

insert into stu_wish values (2012211104,10013,20015);

insert into stu_wish values (2012211105,10013,20012);

insert into stu_wish values (2012211106,10015,20013);

insert into stu_wish values (2012211107,10011,20012);

insert into stu_wish values (2012211108,10012,20011);

insert into stu_wish values (2012211109,10012,20014);

insert into stu_wish values (2012311110,10014,20015);

insert into stu_wish(stu_num,fir_university_id) values (2012341401,10021);

insert into stu_wish(stu_num,fir_university_id) values (2012341402,10022);

insert into stu_wish(stu_num,fir_university_id) values (2012341403,10023);

insert into stu_wish(stu_num,fir_university_id) values (2012341404,10032);

insert into stu_wish(stu_num,fir_university_id) values (2012341405,10032);

insert into stu_wish(stu_num,fir_university_id) values (2012341406,10031);

insert into stu_wish(stu_num,fir_university_id) values (2012341407,10033);

3.建立大学信息表（university_info） www.2cto.com

create table university_info (

uni_id number(5) primary key,

uni_name varchar2(10) not null,

batch_id number(5),

low_cri number(4,1));

insert into university_info values(10001,'TsingHua',1001,632);

insert into university_info values(10002,'BeijingUni',1001,629);