D
DUNNER7
Me again! I am prepraring to construct a school database, but would like
some advice with a structure issue. I operate an alternative school within
the Pittsburgh Public schools for about 300 students. They will have records
for discipline, classes, parent contacts/phone calls, attendance while they
attend my school. My 300 students may come or go throughout the year back to
their "home school" depending upon the length of time they are assigned to me
to make up course work or for expulsions from their home school. There are
10,000 to 13,000 students within the demographic area that I serve (grades
6-12), so throughout the 09-10 school year I might see 1200 to 2000 of the
total number of kids.
Here is my question. I have the necessary demographic information for the
10,000-13,000 students in the district's student information system. I would
like to create a table with every student's necessary information. However,
we will only be serving a small number of the students at any one time (300).
Would I make two seperate student tables? 1. with all students and maybe put
a checkbox to designate them as active when/if they come to my school. 2.
Take the "active" students into a seperate table and use that to perform all
of my operations with discipline, attendance, etc. I am not an expert, but
it seems that a table of 300 would be faster than a table of 10,000.
The alternative would be to enroll each student as they are assigned to my
school, but that would mean creating a form to fill out each student as they
entered and entering all of the demographic information into a table. If the
information is already there is seems more efficient to just locate their
name and place a check to activate them into our database.
Sorry so long, but wanted to give as much info as possible.
Thanks,
Del Dobbs
some advice with a structure issue. I operate an alternative school within
the Pittsburgh Public schools for about 300 students. They will have records
for discipline, classes, parent contacts/phone calls, attendance while they
attend my school. My 300 students may come or go throughout the year back to
their "home school" depending upon the length of time they are assigned to me
to make up course work or for expulsions from their home school. There are
10,000 to 13,000 students within the demographic area that I serve (grades
6-12), so throughout the 09-10 school year I might see 1200 to 2000 of the
total number of kids.
Here is my question. I have the necessary demographic information for the
10,000-13,000 students in the district's student information system. I would
like to create a table with every student's necessary information. However,
we will only be serving a small number of the students at any one time (300).
Would I make two seperate student tables? 1. with all students and maybe put
a checkbox to designate them as active when/if they come to my school. 2.
Take the "active" students into a seperate table and use that to perform all
of my operations with discipline, attendance, etc. I am not an expert, but
it seems that a table of 300 would be faster than a table of 10,000.
The alternative would be to enroll each student as they are assigned to my
school, but that would mean creating a form to fill out each student as they
entered and entering all of the demographic information into a table. If the
information is already there is seems more efficient to just locate their
name and place a check to activate them into our database.
Sorry so long, but wanted to give as much info as possible.
Thanks,
Del Dobbs