i am needing advice on db structure

I am trying to develop a database web with several databases with relationships so I can pull data from each database with like column... and I'm stumped on how I am going to structure it. I think if I can structure it correctly, I can build it. : )

Here is the idea:

Using php and mysql:
All data will be accessed over the web:

I have teachers creating lesson plans with forms, editing, writing, etc. They will also be editing student records.
Students will also be able to view their records.

The lesson plans will need to be forms that can call on a db containing standards...a list of goals with. There are about two hundred standards for 7-12 grade. Each student will be responsible for all 200+ standards.

A teacher will edit the student's standards list, plus the lessons they write will contain information on the standards addressed in teh lesson.

Teachers will then be able to call up a lesson, see the standards addressed, see which student were given the lesson, how they performed, etc.

Students will be able to read their records, click on a standard, see what lessons/assessments went with the standards...

this will build year after year, so each standard (200+) will begin to accumulate numerous lessons and assessments that allign to that standard. student information will need to be deleted after a time...so their data can't be too spread out...


My mental block...
I know I need only one list of standards...
One list of teacher and student names for login, ref. etc.
And maybe one database for lesson plans/ assessments...
and one for scores on the standards...

that is four db. I can imaging the student/teacher login and info. db, and the standards db, and the lesson plan db, but the score db looks very overwhelming...

student db : each student has id. example, stud.11.
stud.11 is signed up for test 1, and gets a 4 as score on standard 123. the the db with scores will show record :
stud.11, test 1, standard123, 4. a row like this?


We will have 500 students and 200+ standards, what is the best way to set this up to manage this many?

I think you're a bit confused on the basics of database design, but, you don't need to make multiple databases for one application (in 99.99% of all situations). You want to have multiple TABLES. I'd suggest you get a book on database design or find some good tutorials online before you get started. Until you do that, here's a good start on what you need for a project like this...

tables:

TABLE: teacher_Info
FIELDS:
teacher_Id
firstName
lastName
userName
passWord
fields for other info that you want to keep recorded...

TABLE:lesson_Plans
FIELDS:
lesson_Id
teacher_Id (foreign key to teachers)
fields for lesson plan info

TABLE:assessment_Info
FIELDS:
assessment_Id
lesson_Id (foreign key to lesson_Plans table)
fields for assessments

TABLE:assessment_Scores
FIELDS:
assessmentScore_Id
assessment_Id (foreign key to assessment_Info table)
student_Id (foreign key to student_Info)
fields for test result info

TABLE:student_Info
FIELDS:
student_Id
firstName
lastName
userName
passWord
fields for other info you want here

TABLE:student_Records
FIELDS:
record_Id
student_Id (foreign key to student_Info)
fields for records...

TABLE:standards_Info
FIELDS:
standard_Id
fields for standards ...

TABLE:standards_Scores
FIELDS:
standardScore_Id
standard_Id (foreign key to standards_Info)
student_Id (foreign key to student_Info)

That should get you started.

I wrote db when I should have written table, my bad. You suggestions are right on the money. Thank you.