ʱ : һ 企业工资福利社会保障系统毕业设计(论文) - 百度文库ϿʼĶ
4 ϵͳ
4.1 4.1.1 ϵͳ
˽ûҪûΪϵͳʹԱԱԱ˽ϵͳܡܵȷҪûӲáڴʽȷ㡣ûҪģϵͳ档ϵͳģһϵеͼɡϵͳĿ߱Ĺܡ 4.1.2 ϵͳIJ
ϵͳϸĻϣһͼꡢ ûµҪĽģ͡γϵͳģ͡ дϵͳ˵顣 4.2 ݿ
ݿϵͳĻʯ,ݿֱӰ쵽ϵͳƳɰ,ڶݿƽרŲ
ݿǰʵʵģתݿģ͵Ḷ́ǽݿӦϵͳĺ⡣ݿ⼰ӦõܶõݿƵĻ֮ϣݿһвĻݿƲãôһݿܵķЧġݿƵĹؼʹƵݿܺش洢ûݣûݴʾ
ûϢ
4-1 ûϢ ûϢUserInformation ֶ User_ID User_Name Password Popedom
Ϣ
4-2 Ϣ Int varchar varchar varchar ˵ Ա Ա Ȩ С 11 20 20 20 ǷΪ NOT NULL NOT NULL NOT NULL NOT NULL ϢDepartmentInformation ֶ
˵ С ǷΪ
D_Number D_Name D_Count
ԱϢ:
int varchar varchar ű 11 20 20 NOT NULL NOT NULL NOT NULL 4-3 ԱϢ
ԱϢEmployeeInformation ֶ E_Number E_Name E_Sex E_BornDate E_Marriage E_PoliticsVisage E_SchoolAge E_EnterDate E_InDueFormDate E_Department E_Headship E_Estate E_Remark
ѵϢ
4-4 ѵϢ
int varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar varchar ˵ Ա Ա ״̬ ò ѧ 빫˾ʱ תʱ ְ ״̬ ע С 11 20 2 30 4 20 20 30 30 20 20 20 500 ǷΪ NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL ѵϢTrainInformation ֶ T_Number T_Content T_Name T_Date T_Money
нϢ
varchar varchar varchar int int ˵ ѵ ѵ ѵԱ ѵ ѵ С 20 100 20 11 11 ǷΪ NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL
4-5 нϢ
нϢWageInformation ֶ W_Number W_Name W_BasicWage W_Boon W_Bonus W_CountMethod W_jin W_FactWage
Ϣ
4-6 Ϣ
int varchar int int int varchar varchar int ˵ Ա Ա 㷽 һ ʵ С 11 30 11 11 11 50 50 11 ǷΪ NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL ϢEncouragementPunishInformation ֶ EP_Number EP_Name EP_Date EP_Address EP_Causation EP_Remark 4.3 ϵͳģ 4.3.1 ϵͳ
ϵͳģµ¼/ɾû˳¼ ģĸ˻롣 µ¼лû֮ĵ¼
/ɾûµĵ¼ûɾеû ˳¼˳ϵͳ
int varchar varchar varchar varchar varchar ˵ Ա Ա ʱ ص ԭ ע С 11 30 30 50 200 500 ǷΪ NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL
4.3.2 Ϣ
µ¼ϵͳ ɾû˳ϵͳϢԱϢϢУԱϢְѵϢϢϢнϢ
ѵϢӣ༭ϵͳûϢ
ϢɶԱĻϢصIJ ϢԾԱϢй
нϢÿԱнϢӡɾġ ϢԲŵϢӡɾġ
ͼ4-2 Ϣ ԱϢ Ϣ Ϣ ͼ4-1 ϵͳ
ѵϢϢϢнϢ4.3.3 Ϣѯ
ϢѯԱϢѯϢѯԱϢѯְѵϢѯϢѯϢѯнϢѯ
ѵϢѯѯԱɣѧϰϵ¼ĽԱһ֡ ϢѯѯԱĻϢǷѻ飬ְλȡ
ϢѯѯԱڹڼõĽǹ©ܵĴ