Jump to content

attendance redeaux


This topic is 8035 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I was about to embark on an attendance (presence at school) database with repeating fields until I saw the discussions going on about how taking it relational is the way to go. I'm still thinking that a repeating field with 31 repetitions would handle it fairly simply and be able to total up tardies and absenses.

Is it that bad to head down this road?

Link to comment
Share on other sites

Hi,

the bottom line would be do you want to report or search the information stored in the repeating fields.

Yes, you can get totals of repetitions, but if you want a report of who was tardy over a specific period, broken down by class, then you have no hope with repeating fields.

If you do then definitely create a relational database.

If you give us some more information, we can point you in the right direction.

Link to comment
Share on other sites

Thanks for responding. It was the Nbrown "repeating field" post that got me thinking. His/her db was a little more elaborate than I need. I think the relational way sound more thorough and scalable (I'm sure someone's gonna want to track it eventually) So, would it be something like this:

A student db with every kid which relates to:

A month db with months (from sept-jun) for each kid which relates to:

A days db with day for each of the kids month.

These would all be related by a student id. I'm not sure, I kind of get lost thinking about it.

Link to comment
Share on other sites

You probably don't need a "Month" database, just a "Days." The days can easily be searched and sorted by week or month or year when needed.

Link to comment
Share on other sites

Yeh, I'm the relationship is starting to clear up for me a bit. Would it be wise to split this attendance days by primary and middle school since we're talking about 175 school days X 240 kids. That's around 42,000 records! They won't be storing much info, but it still seems bulky.

Link to comment
Share on other sites

42,000 records that contain, what, 3 fields -- date, child id, and attended (and maybe a reason for absence?) -- should not be a problem.

Link to comment
Share on other sites

This topic is 8035 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.