内蒙古科技大学课程设计说明书

('157','肖晶','女','1122337','本科','2011-2012年兼职导游，年正式导游'), ('158',' 李亚飞','男','1122338','硕士','2011-2012年兼职导游，年正式导游'), ('159','韩冰冰','女','1122339','硕士','2009-2012年正式导游，年导游副组长'); insert into

tourist(tourist_id,tourist_name,tourist_sex,tourist_num,tourist_address,tourist_age,tourist_tel, tourist_occupation,tourist_income,Email,group_id,staff_id) values('510','王英英','女','123456789009876543','内大','17','2233440','学生','0',null,'310','150'),

('511','张少军','男','123456789009876544','内大','37','2233441','厨师','120000',null,'311','151'),

('512','刘增杰','男','123456789009876545','内科大','35','2233442','工程师','240000',null,'312','152'),

('513','王佳佳','女','123456789009876546','内工大','45','2233443','建筑师','360000',null,'313','153'),

('514','张含韵','女','123456789009876547','内大','19','2233444','学生','0',null,'314','154'),

('515','李如季','女','123456789009876548','内工大','25','2233445','白领','120000',null,'315','155'),

('516','赵登攀','男','123456789009876549','内大','27','2233446','白领','120000',null,'316','156'),

('517','哈图','男','123456789009876550','内农大','49','2233447','退休人员','78000',null,'317','157'),

('518','蒙林','男','123456789009876551','内大','32','2233448','个体','200000',null,'318','158'),

('519','张英俊','男','123456789009876552','内科大','37','2233449','保安','56000',null,'319','159');

37

内蒙古科技大学课程设计说明书

insert into route(route_id,route_name,route_introduce,route_traffic,route_itinerary,group_id) values('430','华东游','风景秀丽','火车','安排进行','310'), ('431','华北游','风景秀丽','火车','安排进行','311'), ('432','上海游','风景秀丽','高铁','安排进行','312'), ('433','三亚游','海景','飞机','安排进行','313'), ('434','韩国游','海景','轮船','安排进行','314'), ('435','欧洲游','异域风情','飞机','安排进行','315'), ('436','巴厘岛游','异域风情','飞机','安排进行','316'), ('437','马达加斯加','风景秀丽','飞机','安排进行','317'), ('438','拉萨游','风景秀丽','飞机','安排进行','318'), ('439','农家游','风景秀丽','火车','安排进行','319'); insert into

ticket(ticket_id,ticket_num,ticket_out,ticket_destination,ticket_time,ticket_pirce,tourist_id) values('200','H01','北京','青岛','2013-1-1','321','150'), ('201','H02','北京','石家庄','2013-1-5','243','151'), ('202','H03','北京','上海','2013-3-4','573','152'), ('203','F01','南京','三亚','2013-4-7','2110','153'), ('204','L01','烟台','济州岛','2013-5-1','450','154'), ('205','F02','上海','巴黎','2013-5-16','4700','155'), ('206','F03','上海','巴厘岛','2013-10-1','4300','156'), ('207','F04','上海','马达加斯加','2013-7-8','3900','157'), ('208','F05','北京','拉萨','2013-8-9','2100','158'), ('209','H04','北京','昆明','2013-8-17','470','159'); insert into

hotel(hotel_id,hotel_name,hotel_star,hotel_room,hotel_address,hotel_person,hotel_tel,hotel_introduce,

38

内蒙古科技大学课程设计说明书

hotel_surroundings,tourist_id)

values('940','温馨之家','3','1002','青岛开发区','张佳','3344550','干净，整洁','具有最佳视野','510'),

('941','温馨之家','4','4002','石家庄开发区','王琦','3344551','干净，整洁','具有最佳视野','511'),

('942','温馨之家','3','3002','上海开发区','王莉','3344552','干净，整洁','具有最佳视野','512'),

('943','海边之家','4','1002','三亚海边','王力','3344553','干净，整洁','具有最佳视野','513'),

('944','济州之家','5','10020','济州岛','韩宇','3344554','干净，整洁','具有最佳视野','514'),

('945','浪漫酒店','4','7002','巴黎','王乐','3344555','干净，整洁','具有最佳视野','515'), ('946','温馨之家','3','9002','巴厘岛','张杰','3344556','干净，整洁','具有最佳视野','516'),

('947','温馨之家','3','5002','马达加斯加','汉克','3344557','干净，整洁','具有最佳视野','517'),

('948','温馨之家','4','1002','拉萨','赵静','3344558','干净，整洁','具有最佳视野','518'), ('949','温馨之家','4','2002','昆明郊区','呼东','3344559','干净，整洁','具有最佳视野','519');

insert into serve(serve_time,serve_event,tourist_id,staff_id) values('2013-1-1','导游','510','150'), ('2013-1-5','导游','511','151'), ('2013-3-4','司机','512','152'), ('2013-4-7','导游','513','153'), ('2013-5-1','导游','514','154'), ('2013-5-16','司机','515','155'),

39

内蒙古科技大学课程设计说明书

('2013-10-1','导游','516','156'), ('2013-7-8','司机','517','157'), ('2013-8-9','导游','518','158'), ('2013-8-17','导游','519','159');

建外键：

alter table tour add

constraint route_id foreign key (route_id) references route(route_id); alter table tour add

constraint staff2_id foreign key (staff2_id) references staff(staff_id); alter table hotel add

constraint tourist_id foreign key (tourist_id) references tourist(tourist_id); alter table route add

constraint group_id foreign key (group_id) references tour(group_id); alter table serve add

constraint staff_id foreign key (staff_id) references staff(staff_id); alter table serve add

constraint tourist1_id foreign key (tourist1_id) references tourist(tourist_id); alter table ticket add

40