数据库课程设计报告源代码
-use kjq111007307/*创立一个部门信息表包含"部门号,部门名,部门经理,人数属性列*/createtable department(depart_no char(2)primarykey, depart_name char(30)notnull, depart_manage char(6)notnull, depart_people intnotnull)/*创立一个职位信息表包含"职位,根本薪资,福利,失业保险,住房公积金属性列*/createtable position(pos char(30)primarykey, basesalary floatnotnull, benefits floatnotnull, insurances floatnotnull, housing_funds floatnotnull)/*创立一个职工信息表包含"职工号,职工名,性别,年龄,学历,部门号,职位"属性列*/createtable staff_message(staff_no char(4)primarykey, staff_name char(10)notnull, staff_sex char(2)check(staff_sex in('男','女'), staff_age intnotnull, staff_edu char(10)notnull, staff_dep char(2)notnull, staff_job char(30)notnull,foreignkey(staff_dep)references department(depart_no),foreignkey(staff_job)references position(pos)/*创立一个员工考勤表包含"职工号,年月,迟到,缺勤,加班属性列*/createtable staff_days(staff_no char(4), month_date char(6), staff_late intnotnull, staff_absent intnotnull, workoverdays intnotnull,primarykey(staff_no,month_date)/*创立一个薪资表包含"职工号,年月,奖金,罚金,真实薪资属性列*/createtable salary(staff_no char(4), month_date char(6), addsalary floatnotnull, subsalary floatnotnull, relsalary floatnotnull,primarykey(staff_no,month_date)createindex salary_index on salary(month_date asc,staff_no asc);/*部门表信息的录入*/*经理室*/insertinto departmentvalues('01','manage_department','王栋','1');/*财务科*/insertinto departmentvalues('02','financial_department','鹏','3');/*技术科*/insertinto departmentvalues('03','plan_department','代淑英','5');/*销售科*/insertinto departmentvalues('04','market_department','金加容','6');/*职位表信息的录入*/*经理*/insertinto positionvalues('manager','4500','1125','-45','-36');/*副经理*/insertinto positionvalues('assistant_manager','4000','1000','-40','-32');/*办事*/insertinto positionvalues('clerk','3500','875','-35','-28');/*助理*/insertinto positionvalues('assistant','2000','500','-20','-16');/*职工信息表信息的录入*/insertinto staff_messagevalues('0101','王栋','男','38','硕士','01','manager');insertinto staff_messagevalues('0201','鹏','男','35','硕士','02','manager');insertinto staff_messagevalues('0202','程雷','男','30','本科','02','clerk');insertinto staff_messagevalues('0203','王晶晶','女','29','本科','02','assistant');insertinto staff_messagevalues('0301','代淑英','女','35','硕士','03','manager');insertinto staff_messagevalues('0302','燕','女','30','本科','03','assistant_manager');insertinto staff_messagevalues('0303','浩','男','27','本科','03','clerk');insertinto staff_messagevalues('0304','程伟','男','31','本科','03','clerk');insertinto staff_messagevalues('0305','唐琦','女','25','本科','03','assistant');insertinto staff_messagevalues('0401','金加容','女','34','本科','04','manager');insertinto staff_messagevalues('0402','吴辉','男','35','本科','04','assistant_manager');insertinto staff_messagevalues('0403','睿','男','32','本科','04','clerk');insertinto staff_messagevalues('0404','万莉','女','36','本科','04','clerk');insertinto staff_messagevalues('0405','方冬雨','女','31','本科','04','clerk');insertinto staff_messagevalues('0406','晨','女','27','专科','04','assistant');insertinto staff_daysvalues('0101','201205','0','0','0');insertinto staff_daysvalues('0201','201205','0','0','0');insertinto staff_daysvalues('0202','201205','0','0','0');insertinto staff_daysvalues('0203','201205','0','0','0');insertinto staff_daysvalues('0301','201205','0','0','0');insertinto staff_daysvalues('0302','201205','0','0','0');insertinto staff_daysvalues('0303','201205','0','0','0');insertinto staff_daysvalues('0304','201205','0','0','0');insertinto staff_daysvalues('0305','201205','0','0','0');insertinto staff_daysvalues('0401','201205','0','0','0');insertinto staff_daysvalues('0402','201205','0','0','0');insertinto staff_daysvalues('0403','201205','0','0','0');insertinto staff_daysvalues('0404','201205','0','0','0');insertinto staff_daysvalues('0405','201205','0','0','0');insertinto staff_daysvalues('0406','201205','0','0','0');insertinto salaryvalues('0101','201205','0','0','5544');insertinto salaryvalues('0201','201205','0','0','5544');insertinto salaryvalues('0202','201205','0','0','4312');insertinto salaryvalues('0203','201205','0','0','2464');insertinto salaryvalues('0301','201205','0','0','5544');insertinto salaryvalues('0302','201205','0','0','4928');insertinto salaryvalues('0303','201205','0','0','4312');insertinto salaryvalues('0304','201205','0','0','4312');insertinto salaryvalues('0305','201205','0','0','2464');insertinto salaryvalues('0401','201205','0','0','5544');insertinto salaryvalues('0402','201205','0','0','4928');insertinto salaryvalues('0403','201205','0','0','4312');insertinto salaryvalues('0404','201205','0','0','4312');insert