Link to home
Start Free TrialLog in
Avatar of sadee52
sadee52

asked on

database design

actually i want to keep record of employee like  this
Employee name   date                        starttime           endtime          totaltimeworked
Sam                     01/01/2008               8:00                 5:00                8
Sam                     02/01/2008               8:00                 5:00                8
.....
.....
Sam                     30/01/2008                9:00                4:00                 6
Tom                      01/01/2008              8:00                 4:00                 6
......
......
in this way of designing i am duplicating employee name it means for each month against each employee there is almost 30 entries. How can i design it in the best way...
ASKER CERTIFIED SOLUTION
Avatar of Kobe_Lenjou
Kobe_Lenjou
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial