数据库课程设计源代码.docxVIP

use kjq111007307 /*创建一个部门信息表 包含部门号，部门名，部门经理，人数 ”属性列*/ create table departme nt (depart_no depart_ name depart_ma nage depart_peoplechar ( 2) primary keychar ( 30) not null, (depart_no depart_ name depart_ma nage depart_people char (6) not null, int not n ull /*创建一个职位信息表 包含’职位，基本薪资，福利，失业保险，住房公积金”属性列*/ create table positi on (pos char ( 30) primary key basesalary float not n ull, ben efits float not n ull, in sura nces float not n ull, hous in g_fu nds float not null /*创建一个职工信息表 包含“职工号，职工名，性别， 年龄，学历，部门号，职位 “属性列*/ create table staff_ .message (staff_no char (4) primary key , staff_ name char (10) not n ull, staff_sex char (2) check (staff_sex in(男 ,女’)), staff_age int not null, staff_edu char (10) not n ull, staff_dep char (2) not null, staff_job char (30) not n ull, foreig n key (staff_dep ) referen ces departme nt (depart_no foreig n key (staff_job ) referen ces positi on (pos ) ) /*创建一个员工考勤表 包含’职工号，年月，迟到，缺勤，加班 ”属性列*/ create table staff_days (staff_no char (4), mon th_date char (6), staff_late int not null, staff_abse nt int not n ull, workoverdays int not n ull, primary key ) (staff_ no ,month_date ) /*创建一个薪资表 包含’职工号，年月，奖金，罚金，真实薪资 ”属性列*/ create table salary (staff_no char (4), mon th_date char (6), addsalary float not n ull, subsalary float not n ull, relsalary float not n ull, primary key (staff_no ,month_date ) asc ); asc ); create index salary_index on salary ( month_date asc , staff_no /*部门表信息的录入*/ /*经理室*/ in sertinto departme ntvalues (01 , manage_department/*财务科 in sert into departme nt values (01 , manage_department /*财务科*/ in sert into departme nt values ( 02 , financial_department /*技术科*/ in sert into departme nt values ( 03 , plan_department /*销售科*/ in sert into departme nt values ( 04 , market_department 王栋,1); 张鹏,3); 代淑英,5); 金加容,6); /*职位表信息的录入*/ /*经理*/ in sert into positi on values ( manager ,4500 ,1125 , -45 , -36); /*副经理*/ in sert into positi on values ( assistant_manager , 4000 , 1000 , -40 , -32); /*办事*/ in sert into positi on values ( clerk , 3500