Attendance with Personal Info. Database Structure

[cary1234]

I already created a website that has some basic functions for monitoring the attendance of employee, but right now I want to upgrade it. I want to add the exact date of the meeting and if possible make all of the meetings visible and if they are absent or present during those meeting.

 

Take note that every person has a different meeting schedule, will you help me to construct a great database structure for that? Right now I think I will changed almost 80% of my website due to poor construction of database. Please help me.

 

[/img]

 

Uploaded with ImageShack.us

[Barand]

The simplest model would be something like this

+------------+          +---------------+        +-------------+
|  user      |          | user_schedule |        |  meeting    |
+------------+          +---------------+        +-------------+
| user_id    |----+     | id            |   +----| meeting_id  |
| firstname  |    +----<| user_id       |   |    | meeting_date|
| lastname   |          | meeting_id    |>--+    | description |
| birthdate  |          | present       |        +-------------+
| address    |          +---------------+
+------------+

Schedule would be those users invited to a meeting. It would be simple to then construct a form listing invitees for a meeting and check boxes to indicate who attended.

 

Don't store users' age. That can be calculated from birth date when required.

Edited September 13, 2013 by Barand

[cary1234]

Ahhh, thanks Barand. Thats a very good idea. Yeah you have a point there on not storing age. Thanks!