How to create tables for school based curriculum

[Guest]

I am setting up a database for the school that I work at, but I have been
unsuccessful so far. What I want to do is have a table with the students'
information and tables with the state standards for each: math, reading, and
writing. There are too many to fit all into one table (>255). How do I link
the studentID(PK) to the corresponding studentID(PK) in each table and their
grades? Essentially, I am trying to create one record using multiple tables.
Is that possible?

Table: Student
StudentID Last First Teacher
1 Snuffie Joe Smith

Table: Math
StudentID Standard 1 Standard 2 Standard3
1 A B A

Table: Reading
StudentID Standard 1 Standard 2 Standard3
1 B B C

 

[Allen Browne]

The basic structure is explained in this article:
Relationships between Tables (School Grades example)
at:
http://members.iinet.net.au/~allenbrowne/casu-06.html

I'm not clear from your post, but if there are standards that apply to
different subjects, you will need a SubjectStandard table, and then the
students may need to relate to a SubjectStandard instead of a subject.

 

[Guest]

Thanks for the article. It helped partially, but using it and another
article I figured out how to accomplish what I am trying to do. Using the
StudentID (PrimaryKey) in the Student table; then using the Lookup Wizard
(and looking into StudentID in the Student table) in each subsequent table.
It is different from your article in the fact that each standard is a field
and not a record. Essentially, I am recreating the list of students in each
table, but only by using their StudentID; then through a relationship tying
them all together. I am able to sort for specific students and specific
standards that are needed to record into.
If this does not make sense, and you would like to see what I am
explaining, I can email a copy of it.

Thanks again,
Brent

 

[Allen Browne]

Please don't send an email copy. I already have lots of databases.

Using the standards are field names does not sound attractive to me. You
have lots of fields to search through to find out if a student met all
standards, for example. And it means redesigning your database every time a
new standard is added.