·¢²¼Ê±¼ä : ÐÇÆÚÈÕ ÎÄÕÂÔ±¹¤¿¼ÇÚ¹ÜÀí×Óϵͳ¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ00555525482fb4daa58d4b13
Êý¾Ý¿âϵͳÔÀí¿Î³ÌÉè¼Æ˵Ã÷Êé¨D¨DÔ±¹¤¿¼ÇÚ¹ÜÀí×Óϵͳ
Ô±¹¤ÊµÌåÊôÐÔE-R·ÖͼÈçͼ2.2.1Ëùʾ£º Ô±¹¤ÐÔ±ð Ô±¹¤ Ô±¹¤±àºÅ Ô±¹¤ÐÕÃû ³öÉúÈÕÆÚ
ͼ2.2.1 Ô±¹¤ÊµÌåÊôÐÔE-R·Öͼ
³ö²î¼Ç¼ʵÌåÊôÐÔE-R·ÖͼÈçͼ2.2.2Ëùʾ£º
³ö²îÃèÊö ³ö²î¼Ç¼ ³ö²îÆðʼʱ¼ä ³ö²î±àºÅ ³ö²î½áÊøʱ¼ä Ô±¹¤±àºÅ
ͼ2.2.2³ö²î¼Ç¼ʵÌåÊôÐÔE-R·Öͼ
Çë¼Ù¼Ç¼ʵÌåÊôÐÔE-R·ÖͼÈçͼ2.2.3Ëùʾ£º
Çë¼Ù¼Ç¼
Çë¼ÙÔÒò
Çë¼Ù±àºÅ Çë¼ÙÆðʼʱ¼ä
3
Ô±¹¤±àºÅ Çë¼Ù½áÊøʱ¼ä Êý¾Ý¿âϵͳÔÀí¿Î³ÌÉè¼Æ˵Ã÷Êé¨D¨DÔ±¹¤¿¼ÇÚ¹ÜÀí×Óϵͳ
ͼ2.2.3 Çë¼Ù¼Ç¼ʵÌåÊôÐÔE-R·Öͼ
¼Ó°à¼Ç¼ʵÌåÊôÐÔE-R·ÖͼÈçͼ2.2.4Ëùʾ£º
¼Ó°àʱ¼ä³¤¶È Ô±¹¤±àºÅ ¼Ó°à¼Ç¼ ÈÕÆÚ ¼Ó°à±àºÅ
ͼ2.2.4 ¼Ó°à¼Ç¼ʵÌåÊôÐÔE-R·Öͼ
³öÇڼǼʵÌåÊôÐÔE-R·ÖͼÈçͼ2.2.5Ëùʾ£º
ÈÕÆÚ ³öÇڼǼ Ô±¹¤±àºÅ ÉÏ°àʱ¼ä ³öÇÚ±àºÅ Ï°àʱ¼ä
ͼ2.2.5³öÇڼǼʵÌåÊôÐÔE-R·Öͼ
Ö°³ÆʵÌåÊôÐÔE-R·ÖͼÈçͼ2.2.6Ëùʾ£º
4
Ô±¹¤±àºÅ Ö°³Æ ¼Ó°à·Ñ ²¹Öú×ʽð Ö°³ÆÃûÊý¾Ý¿âϵͳÔÀí¿Î³ÌÉè¼Æ˵Ã÷Êé¨D¨DÔ±¹¤¿¼ÇÚ¹ÜÀí×Óϵͳ
ͼ2.2.6 Ö°³ÆʵÌåÊôÐÔE-R·Öͼ
Ô¶ȿ¼ÇÚʵÌåÊôÐÔE-R·ÖͼÈçͼ2.2.7Ëùʾ£º ×ܳö²îÌìÊý ³Ùµ½´ÎÊý ÔçÍË´ÎÊý ×ÜÇë¼Ù´ÎÊý ¿õ¹¤´ÎÊý Ô¶ȿ¼ÇÚ ÈÕÆÚ ×ܼӰà´ÎÊý ¿¼ÇÚ±àºÅ Ô±¹¤±àºÅ ×ܹ¤×÷ʱ¼ä ͼ2.2.7 Ô¶ȿ¼ÇÚʵÌåÊôÐÔE-R·Öͼ
¹¤×ÊʵÌåÊôÐÔE-R·ÖͼÈçͼ2.2.8Ëùʾ£º
»ù±¾¹¤×Ê ¿Û³ý¹¤×Ê Êµ·¢¹¤×Ê ¹¤×Ê ½±½ð Ô±¹¤±àºÅ ¹¤×ʱàºÅ
ͼ2.2.8 ¹¤×ÊʵÌåÊôÐÔE-R·Öͼ
5
Êý¾Ý¿âϵͳÔÀí¿Î³ÌÉè¼Æ˵Ã÷Êé¨D¨DÔ±¹¤¿¼ÇÚ¹ÜÀí×Óϵͳ
Ô±¹¤¹ÜÀí×ÓϵͳE-RͼÈçͼ2.2.9Ëùʾ£º
1 Ô±¹¤ 1 ¶ÔÓ¦ 1 ¹¤×Ê N
ͼ2.2.9 Ô±¹¤¹ÜÀí×ÓϵͳE-Rͼ
²ÎÕÕ Çë¼Ù¼Ç¼ N ³ö²î¼Ç¼ N ×é³É ¼Ó°à¼Ç¼ N ×é³É ³öÇڼǼ N ×é³É 1 Ô¶ȿ¼ÇÚͳ¼Æ 1 ²ÎÕÕ 1 Ö°³ÆÐÅÏ¢ 1 1 ×é³É 1 2.3 Êý¾Ý¿âÂß¼½á¹¹·ÖÎö
¸ù¾Ýͼ2.2.9Ô±¹¤¹ÜÀí×ÓϵͳE-Rͼ£¬¿ÉÒԵõ½ÈçϹØϵģʽ£º Employee (Yno,Yname,Ysex,Birth,Yduty) Travel_register (Travelno,Yno,Tstarttime,Tendtime,Process,Mattendno) Leave_register (Leaveno,Yno,Lstarttime,Lendtime,Reason,Mattendno) Overtime_register (Overtimeno,Yno,Overtimelth,Time,Mattendno) Work_register (Workno,Yno,Time,Ondutytime,Offdutytime,Mattendno) Duty(Yno,Dduty, Allowance, Overtimefei,)
Month_attend(Mattendno,Yno,Time,Ljworktime,Ljleavetime,Ljtraveltime, Ljovertime,Latetimes,Leavetimes,Absenttime,)
Wage (Wageno,Yno,Basicwage, Bonus,Realwage, Reducewage, Dduty)
6