DB example

[JF Bouthillier]

Hi,

I am trying to create a database where absences will be tracked. I am
unsure about how I should design this system...

Can someone give me an example to start off with?

Thanks a lot for your help.

 

[Duane Hookom]

Start with a table of all people
tblPeople
============
peoPeoID autonumber primary key
peoFirstName
peoLastName
....

Create a table of absense codes
tblAttendCodes
================
atcAtCID autonumber primary key
atcTitle values like Sick, Lame, Lazy,...
atcStatus

Create a table of people/attendance
tblPeopleAttendance
==============
peaPeAID autonumber primary key
peaPeoID link to tblPeople.peoPeoID
peaAtCID link to tblAttendCodes.atcAtCID
peaHours maybe
peaComments