This is probably a simple question, but.... I'm trying to put together a Reading Level database to be
used to record reading information for elementary school students. There are a number of items students are
scored on for their reading level including comprehension, accuracy, interpretation,
etc. The database needs to keep track of
two levels of reading I'm calling UpperLevel and Lowerlevel. These levels are determined by the book the
teacher uses to test the student's reading ability, so it is the book that decides the level, not the student or the grade the student is in. Right now I have five tables to hold the
data: StudentInfo, TestingDates,
BookInfo, UpperLevel, LowerLevel.
StudentInfo has fields like: StudentID {primary key}, LastName, FirstName,
Grade, Teacher, etc.
TestingDates includes: TestID {primary key}, TestDate, Session {meaning fall, winter, spring}
BookInfo contains fields about the books used,
including: TextID {primary key},
TextTitle, TextLevel, TextWordCount, etc.
LowerLevel contains fields about the student's scores
based on the selected book used, including: LowerID {primary key}, Errors, Expression, Rate, etc.
UpperLevel is basically the same as LowerLevel with a few
differences on what is measured. The
structure is the same with a primary key of UpperID
Assuming these five tables represent a logical approach
to storing the data, I cannot figure out how they relate to each other so that
I can determine what all of the testing data was for a particular student. Or, so I can see all of the data for a
particular teacher's class in order to help them make up student reading groups
based on this data.
Thanks for any help you can offer.
Jerry
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar