How to create tables for school based curriculum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ma Rung - 20 Dec 2004 08:17 GMT

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

Reply to this Message

Allen Browne - 20 Dec 2004 09:04 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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'
[quoted text clipped - 19 lines]
> StudentID Standard 1 Standard 2 Standard3
> 1 B B C

Reply to this Message

Ma Rung - 20 Dec 2004 17:37 GMT

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

> The basic structure is explained in this article:
> Relationships between Tables (School Grades example)
[quoted text clipped - 28 lines]
> > StudentID Standard 1 Standard 2 Standard3
> > 1 B B C

Reply to this Message

Allen Browne - 20 Dec 2004 17:57 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 51 lines]
>> > StudentID Standard 1 Standard 2 Standard3
>> > 1 B B C

Reply to this Message