Re: Database structure for a small Time and Attendance application

[Peter Brawley]

> I will have to store these raw logs in the databas

Obviously the table for raw data needs columns matching the .csv.

> how to store information once computed

That's called designing a database. Have you read up on that subject? If not, do so, then follow a logical method, eg http://www.artfulsoftware.com/dbdesignbasics.html

The .csv input you show doesn't distinquish loggin in from logging out, so it seems for this problem you will need to take the first success as in, the next success as out etc. When you're working in the real world, one hopes your designs will leave less to such guessing.