Oops.
This is actually only a piece of the full complement of data that I'm working with. I forgot to put in some stuff that would have been in other data.
AssessmentSubject has another FK in it to a table that has FKstateID
So really it is
AssessmentSubject
------------------
dataID
assessmentID
subjectID
[grade/age thing here]
nonstandard
and dataID comes from the table data (I really need to find a better name for this table)
Data
-----
id INT
[other referential data]
stateID CHAR(2)
referenceYear
description
I'm working on drawing this out in MySQL workbench so if an erm would be helpful I could toss that up.
When I said "spot the ones with no delivery information" I meant the specific AssesmentSubject combination.
So I might have something like:
(State: assessment: delivery[grades/ages]: subject)
Indiana: ISTAR: No delivery information: no subject information
or (I just noticed this)
I might have
OK: Alternate assessment: All: Portfolio of required subjects
Other data examples:
Alabama: Alternate Assessment: 3-8, 11, 12: Not specified
Arizona: AIMS: 3,5,8,10,11,12:Reading, Math, Writing, Listening, Speaking
Arizona: Alternate SAT-9: 2-9: Reading, Language, Math
Hawaii: Alterante Assessment: No Information Found: No Information Found
Idaho: Alternate Assessment: K-10: Reading, Language, Math(2-10)
NY: NYSAA: Ages 10-11, 14-15, 17-18:English Language Arts, Math
Michigan: MI-Access: Ages 9,10,13,14,17,18: 8 Performance Expectations
So I guess there's actually a lot more going on here. Because I'll need to have values for the "Not Specified" vs "No information found" right?
If it's helpful, the data is here:
http://education.umn.edu/nceo/OnlinePubs/Technical40.htm Appendix C and Appendix G
Does this make more sense?