Attendance Database Example Needed

  • Thread starter Thread starter Doug MacDonald
  • Start date Start date
D

Doug MacDonald

Are there any examples of databases created to keep daily
attendance for several classes per day. I'm not quite
sure what the best way is to set up the tables. One table
with 30 some fields to cover each day as well as month and
person data? A separate table for each class? Tables for
each month? New table each year?

I probably don't even have all the requirements figured
out yet. Any help would be welcome. There must be
examples out there someplace.

Thanks,

Doug
 
careful analysis of what you really need
will help you design/create a good database

not a good choice to have one table with 30 fields..
access is a relational database.
 
NO! (to all of these questions!) You never want to have separate tables
that hold essentially the same data, but divided by class, month, year, or
what have you. You also do not want to have fields which hold the same data
(i.e. Day1, Day2, ... Day30). This "spreadsheet thinking" has no place in
relational database design.

You need to look into Normalization theory a little before going any
further. I suggest getting a copy of "Database Design for Mere Mortals" by
Michael Hernandez. Also, I have some tutorials on my website (see sig
below) that are designed to walk you through the Hernandez process. You can
find them in the Tutorials (Design) section.
 
Back
Top