Jump to content

Attendance with Personal Info. Database Structure


Recommended Posts

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. :)

 


 

Uploaded with ImageShack.us

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 by Barand
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.