【正文】 Accident)基本信息表，用于記錄宿舍事故注冊(cè)的基本信息： 宿舍事故注冊(cè)基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性AcNoint0000~9999是Not nullAcTypechar(10)否Not nullStuNochar(30)00000000~999999999是Not nullAcDatedatetime是Not nullAcArticalchar(30)否Not nullAcVerifybool否NullSGNamechar(15)是NullAcArNumint大于等于0否Not nullAcStuPhchar(12)否Null(AccidentResearch)基本信息表，用于記錄宿舍事故調(diào)查的基本信息： 事故調(diào)查基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性AcNoint0000~9999是Not nullARNamechar(15)是Not nullSGNamechar(15)是 Not nullARResultbool否Not null(AccidentCompensate)基本信息表，用于記錄宿舍事故賠償?shù)幕拘畔ⅲ?宿舍事故賠償基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性AcNoint0000~9999是Not nullACStuchar(10)00000000～999999999是Not nullAcArticalchar(30)否Not nullACDatedatetime否Not nullSGNamechar(15)是Not null附錄2 存儲(chǔ)過(guò)程定義:CREATE PROCEDURE p1_Worker_Insert @worker_no char(5), @worker_name char(10)， @work_type char(8), @work_wage int, @worker_sex char(2), @work_time char(30), @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4) as insert into Worker values(@worker_no, @worker_name, @work_type, @work_wage, @worker_sex, @work_time, @work_time, @dormitory_no,@dormitory_campus, @dormitory_location)。:create procedure p2_Dormitory_Insert @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4), @dormitory_phone char(12), @dormitory_administer char(10) as insert into Dormitory values(@dormitory_no, @dormitory_campus, @dormitory_location, @dormitory_phone, @dormitory_administer)。:create procedure p3_Room_Insert @room_no char(6), @room_header char(10), @roomer_grade char(4), @roomer_department char(20), @roomer_perfection char(20), @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4) as insert into Room values(@room_no, @room_header, @roomer_grade, @roomer_department,@roomer_perfection, @dormitory_no, @dormitory_campus, @dormitory_location)。:create procedure p4_Fitment_Insert@fitment_name char(16),@fitment_price float,@fitment_number int,@dormitory_no smallint,@dormitory_campus char(4),@dormitory_location char(4)asinsert to Fitmentvalues(@fitment_name, @fitment_price, @fitment_number, @dormitory_no, @dormitory_campus, @dormitory_location)。:create procedure p5_Student_Insert @student_no char(9), @department_name char(20), @student_name char(10), @student_sex char(2), @student_home char(10), @student_borth datetime, @student_enter_time datetime, @student_perfection char(20), @student_class int, @room_no char(6), @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4) as insert into Studentvalues(@student_no, @department_name, @student_name, @student_sex , @student_home, @student_borth, @student_enter_time, @student_perfection, @student_class, @room_no, @dormitory_no, @dormitory_campus, @dormitory_location)。:create procedure p6_SafeGuard_Insert @safeguard_name char(15), @safeguard_worker_num int, @safeguard_header char(10), @safeguard_phone char(12) as insert into SGName values(@safeguard_name, @safeguard_worker_num, @safeguard_header, @safeguard_phone)。:create procedure p7_Artical_In_Out_InSert @student_no char(9), @aio_artical char(16), @aio_principal char(9), @aio_date datetime, @aio_no int, @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4) as insert into AIOArtical values(@student_no, @aio_artical, @aio_principal, @aio_date, @dormitory_no, @dormitory_campus, @dormitory_location)。: 的定義create procedure p8_FitmentDestruction_Insert @fitment_name char(16), @student_no char(9), @room_no char(6), @fdf_num int, @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4) as insert to FitmentDestruction values(@fitment_name, @student_no, @room_no, @fdf_num, @dormitory_no, @dormitory_campus, @dormitory_location)。:create procedure p9_FitmentCompensate @fitment_name char(16), @stu_no char(9), @fc_principal char(10), @fc_date datetime, @fc_num int, as insert FitmentDestruction values(@fitment_name, @stu_no, @fc_principal, @fc_date, @fc_num)。:create procedure p10_Accident_Insert @ac_no int, @ac_type char(10), @stu_no char(30), @ac_date datetime, @ac_artical char(30), @ac_verify bool, @sg_name char(15), @ac_ar_num int, @ac_stu_phone char(12) as insert into Accident values(@ac_no, @ac_type, @stu_no, @ac_date, @ac_artical, @ac_verify, @sg_name, @ac_ar_num, @ac_stu_phone)。:create procedure p11_AccidentResearch_Insert @ac_no int, @ar_name char(15), @sg_name char(15), @ar_result bool as insert into AccidentResearchvalues(@ac_no, @ar_name, @sg_name, @ar_result)。:create procedure p12_AccidentCompensate_Insert @ac_no int, @ac_stu char(10), @ac_artical char(30), @ac_date datetime, @sg_name char(15) as insert into AccidentCompensate values(@ac_no, @ac_stu, @ac_artical, @ac_date, @sg_name)。:create procedure p13_Query_Worker @worker_no char(5) as select * from WorView where 編號(hào) = ltrim(@worker_no)。:create procedure p14_Query_Worker @worker_name char(10) as select * from WorView where 姓名 like ltrim(@worker_name)+’%’。：create procedure p15_Delete_Worker @worker_no char(5) as delete from WorView where 編號(hào) = rtrim(ltrim(@worker_no))。：create procedure p16_Delete_Worker @worker_name char(10) as delete from WorView where 姓名 like rtrim(ltrim(@worker_name)附錄3 所有的SQL運(yùn)行語(yǔ)句create database Student_Dormitory_Management。create table Dormitory( DorNo smallint not null, DorCampus char(4) not null, DorLocation char(4) not null, DorPhNo char(12) null, DorAdminist char(10) not null, primary ke