Hehehe

This was a small application that is increasing in the time, by adding other functions/modules/options.

Now i have to redesign one of the modules, and i was looking to the tables that are related with it and i was thinking that i maybe could replace some of the tables...

For example i have one section in the application where the users (workers) need to register hours for every working day, every user belong to a team, but the users can change of team, so the history doesn't be right if i use a normalized table.

Small example:

Team

----------

ID | Name

----------

1 - TeamA

2 - TeamB

Users

------------------

ID | Name | Team

------------------

1 - User1 - 1

WorkDay

-----------------------------------------

Date | User | TimeWasted | Project

-----------------------------------------

27.10.2010 | 1 | 10 | ProjectA

Later the user change to TeamB, now the table looks like this

Users

------------------

ID | Name | Team

------------------

1 - User1 - 2

If i go and try to check where the TeamB worked i'll get the wrong info because i have one row that tells me that it worked in ProjectA.

BTW - The application was built only by me.