[mso] Re: Creating/fixing High school DB in Access :VSMail MX2

April,

You are on the right track.  The best way to get started is to step away
from the computer and start with pen and paper.  List all of the data you
will need to track and try to figure out how it will be stored.  You have a
good start with the class, teacher and student tables.  You did ask about
how to handle classes that run both semesters, I would simply add a field
for length and one for semester in the class table.  If the length field is
set to year then it is available for both semesters, otherwise it is only
available for the semester listed.

As for schedules, you will probably want an Available Class schedule that
would list the instructor(linked to pk of Instructor table), class (linked
to the ok in the class table) and period.  If you chose to, you could
include a simple period table that would list the period number along with
the times so that those aren't repeated.  

Your schedule would probably be next linking to the AvailableClass schedule
and the students schedule.  You will want to build in a check to verify that
the same student does not have multiple classes in the same period as well
as verifying that their schedule is full.

As I said above, the best way to start something like this is to start with
a pen and paper and figure out exactly what you want to include and the
information you want out of it.  You can then figure out how you will need
to query the data.  While you are working out your reporting needs you may
(probably will) find ways you need to modify your data to better fit your
needs.  

If you get stuck on something please feel free to drop us a note in the
group and we will see what we can do to help.

James La Borde
South Western Federal Credit Union

-----Original Message-----
From: 4office [mailto:4office@xxxxxxxxxxxxx]
Sent: Wednesday, October 30, 2002 8:04 AM
To: Office (E-mail); April Pace (E-mail)
Subject: [mso] Creating/fixing High school DB in Access :VSMail MX2


I am trying to figure out what would be the best way to create (high school)
class schedules to A) know who is where and B) potentially be able to track
attendance for both Teachers and Students and grades.

Ok, I have a master list  (table) of:
  1.. all classes (not by period, just available)
  2.. Teachers
  3.. Students
Should I create first a table for each teacher with every class/room/period
or One table for each period with teacher name and room then do the same for
students? (One table for each period with student/class)?  What about the
difference with classes that are 2 semesters long (the entire school year)
and the ones that are only 1 semester long.

From there, thinking a head, (I don't know if this would be a table or
form-subform working on the tables above) how would I do attendance
(absent - excused, absent - unexcused, tardy - excused, tardy - unexcused,
in-school-suspended,off-campus-suspended, etc) say for students in Ms.
Smith's 2nd period class, how would I do grades??  How would I do
attendance/per period for teachers?


Ok, the other problem that I have is on the registration tables for the
students (Right now, in the already poorly designed DB - there is one table
with like 30+ columns that I am trying to break down.  Think about it, they
took the entire registration form that is filled out upon entering the
school and created ONE table for all of it.  And yes, they did the same
thing for the teachers employment application!)

There is a place (need) for the student's home address, mailing address (may
or may not be the home), Legal Guardian's address/contact info, Mother's
address/contact info, and Father's address/contact info.  Now obviously this
could all be the exact same address for each of the 5 contact info, or it
could potentially be 5 different addresses.  How do I set this up with the
least amount of redundancy?? (Note: Contact info is name,relation, and all
phone numbers) Oh and I forgot, there is also a separate place for emergency
info (who to call, relationship, address, phones).

Anybody that has experience with creating (re-creating/fixing) this type of
DB, that may know of anything else that might need to be included, thought
about, that I have not thought of yet, PLEASE let me know.

Thanks for your help.  Also, when you reply to the group, please also cc me
at arpace@xxxxxxxxxxxxxxxxx

April





*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: