Table Design

[Guest]

I am working with an existing database designed by another developer. Within
the datbase there is a table to track hours worked on projects each day

The table was created as shown below

ID
ProjectID
UserID
WeekEndingDate
SunHrs
MonHrs
TueHrs
WedHrs
ThuHrs
FriHrs
SatHrs
....

Wouldn't a better design have been

ID
ProjectID
UserID
Date

Similarily when tracking budget dollars, the following was used
ID
ProjectID
JanDol
FebDol
MarDol
etc

vs
ID
ProjectID
Month

Are both designs for hours and dollars considered acceptable? Any comments
would be greatly appreciated. Thanks.

Weste

 

[Duane Hookom]

You seem to have a much better grasp of table design than the "another
developer". I would avoid creating fields with names like Month and Date
which are function names. Try BudgetMonth and WorkDate.