最新数据库实验 学生宿舍管理系统设计大作业(11)

/*导入公寓楼基本信息*/

insert into Dormitory values('1','woman','Aunt wang','88648256','79','100');

insert into Dormitory values('2','woman','Aunt zhang','88648252','70','100');

insert into Dormitory values('3','woman','Aunt li','88648259','69','100');

insert into Dormitory values('4','woman','uncle wang','88648245','83','100');

insert into Dormitory values('5','woman','Aunt zhao','88648246','68','100');

insert into Dormitory values('6','woman','Aunt qian','88648248','76','100');

/*导入宿舍基本信息*/

insert into Live values('08052201','David','2','314','20080907'); insert into Live values('08052202','lucy','5','202','20080907'); insert into Live values('08052203','jim','2','216','20080907'); insert into Live values('08052204','Tom','4','236','20080907'); insert into Live values('08052205','lily','6','432','20080907'); insert into Live values('08052206','anne','1','613','20080907'); insert into Live values('08052207','Tim','2','231','20080907'); insert into Live values('08052208','jili','5','112','20080907'); insert into Live values('08052209','harry','1','213','20080907'); insert into Live values('08052210','rose','4','202','20080907'); insert into Live values('08052211','arce','2','314','20080907'); insert into Live values('08052212','roon','5','202','20080907'); insert into Live values('08052213','hong','2','216','20080907'); insert into Live values('08052214','wen','4','236','20080907'); insert into Live values('08052215','li','6','432','20080907'); insert into Live values('08052216','Dmdn','1','613','20080907'); insert into Live values('08052217','jiao','2','231','20080907'); insert into Live values('08052218','jili','5','112','20080907'); insert into Live values('08052219','lan','1','213','20080907'); insert into Live values('08052220','grey','4','202','20080907');