最新數(shù)據(jù)庫課程設(shè)計員工信息管理系統(tǒng) 免費下載-文庫吧
2025-04-02 22:41 本頁面
【正文】 varchar合同期限50職稱信息表（title）字段類型說明大小是否為空title_idint職稱序號4NOT NULLtitle_namenvarchar職稱名稱20NOT NULLtitle_desnvarchar備注255學(xué)歷信息表（education）字段類型說明大小是否為空edu_idint學(xué)歷序號4NOT NULLedu_namenvarchar學(xué)歷名稱20NOT NULLedu_desnvarchar備注255職務(wù)信息表（duty）字段類型說明大小是否為空duty_idint職務(wù)序號4NOT NULLduty_namenvarchar職務(wù)名稱20NOT NULLduty_desnvarchar備注255考勤信息表（checkin）字段類型說明大小是否為空emp_idint員工編號4NOT NULLcheck_ymnvarchar員工姓名6NOT NULLw_dayreal應(yīng)出勤天數(shù)4NOT NULLl_numsint遲到次數(shù)4NOT NULLe_numsint早退次數(shù)4NOT NULLh_daysreal請假天數(shù)4NOT NULLn_daysreal曠工天數(shù)4NOT NULLo_daysreal加班天數(shù)4NOT NULLr_daysreal補休天數(shù)4NOT NULLovertime_sreal加班費4NOT NULLd_checkreal扣款4NOT NULLcheck_desnvarchar備注255注：波浪線為主鍵。關(guān)系圖 建立數(shù)據(jù)庫Create table employee(emp_id int(4) not null,emp_name nvarchar(20) not null,sex nvarchar(2) not null,birthday smaldatetime(4) not null,native nvarchar(20),profession nvarchar(20),edu_id int(4),not null,title_id int(4),not null,dept_id int(4),not null,duty_id int(4),not null,emp_date1 smaldatetime(4),not null,emp_date2 smaldatetime(4),not null,emp_des nvarchar(255),zzmm nvarchar(50),ygjstc nvarchar(50),bisx nvarchar(50),ygxz nvarchar(50),htqx nvarchar(50),constraint EmPK primary key(emp_id),constraint EduFK foreign key(edu_id) references education(edu_id),constraint TitleFK foreign key(title_id) references education(title_id),constraint DuFK foreign key(duty_id) references education(duty_id),constraint DeFK foreign key(dept_id) references education(dept_id),)Create table title(title_id int(4) not null,title_name nvarchar(20) not null,title_des nvarchar(255)constraint TiPK primary key(title_id),)Create table education(edu_id int(4) not null,edu _name nvarchar(20) not null,edu _des nvarchar(255)constraint EdPK primary key(edu _id),)Create table duty(duty _id int(4) not null,duty _name nvarchar(20) not null,duty _des nvarchar(255)constraint DuPK primary key(duty _id),)Create table department(dept_id int(4) not null,dept _name nvarchar(20) not null,dept _des nvarchar(255)constraint DePK primary key(dept _id),) 安全性（權(quán)限）grant all privileges on employee to sasagrant all privileges on checkin to sasagrant all privileges on sysuser to sasagrant all privileges on duty to sasagrant all privileges on title to sasagrant all privileges on department to sasagrant all pr ivileges on education to sasa 觸發(fā)器功能：使姓名中不能出現(xiàn)數(shù)字。CREATE TRIGGER T_IN ON FOR INSERT,UpdateAS IF EXISTS ( SELECT * FROM employee WHERE emp_name like 39。%[09]%39。 ) BEGIN RAISERROR(39。錯誤！姓名中不可出現(xiàn)數(shù)字39。,16,1) ROLLBACK RETURN END 建立索引create cluster index pk_duty on duty_idcreate cluster index pk_department on dept_idcreate cluster index pk_title on title_idcreate cluster index pk_education on edu_idcreate cluster index pk_sysuser on user_idcreate cluster index pk_employee on emp_idcreate cluster index pk_checkin on (emp_id,check_ym) VB數(shù)據(jù)庫連接語句Option ExplicitPublic dbConn As New Public loginUser As StringPublic loginOK As BooleanPublic cmdType As StringPublic tUser_id As StringPublic tDept_id As IntegerPublic tEmp_id As IntegerPublic tCheck_ym As StringPublic tQx As StringSub Main() If ConnectToDatabase = False Then MsgBox 連接數(shù)據(jù)庫出錯！ End End If loginOK =
公司管理相關(guān)推薦
鄂ICP備17016276號-1