求一数据库设计

[Mark杨]

考勤系统.

1.上班类型有:
a. 二班 8:00 11:30 14:00 18:00
b. 早班 8:00 16:00
c. 中班 16:00 24:00
d. 晚班 00:00 8:00

2.打卡记录是从打卡机导出来的
登记号(与用户表对应) 时间 checktype(I/O I:上班 O:下班)
1 2010-5-15 7:56:56 I
5 2010-5-15 7:58:55 I
6 2010-5-15 8:02:12 O
22 2010-5-15 8:02:23 O

请问这个考勤系统的数据库要如何设计啊？
不知道 你们理解我的意思没有。。。

[csw200201]

You need
(1) Staff table storing staff information
At a minimum, you will need a StaffID (Identity integer field) primary key

(2) ShiftTypes table store shift information. Suggested columns include
ShiftTypeID (Identity integer field) primary key, StartTime (datetime type), FinishTime (datetime), Active (bit field) - this field can be used to determine if a shift is still being used. You could have shift that are no longer in use. If a particular shift changes starting and finishing time, you should create a new Shift Type to supersede the original one.

(3) Roster table stores Employee ShiftTypeID, actual start and finish time. You need
RosterID (Identity integer), StaffID (foreign key to Employees table), ShiftTypeID (foreign key to ShiftType table), ActualEntryTime (datetime), ActualFinishTime (datetime).

This is a very rudimentary design but it should do what you want give your current specification.

[Mark杨]

[Quote=引用 4 楼 csw200201 的回复:]
You need
(1) Staff table storing staff information
At a minimum, you will need a StaffID (Identity integer field) primary key

(2) ShiftTypes table store shift information. Suggested columns inclu……
[/Quote]

大大 英文好难懂啊

[csw200201]

Use translate.google.com

[messi_yang]

我覺得還是少了點東西吧
如果沒有規定某員工的上班類型的話
不是會出現異常嗎 ?

[Mark杨]

没有自由上班时间的。。。

就几种类型的上班时间

[ziyelengzui]

赞同楼上的说法