Are my tables created correctly (normalized) so far?

I have attached a database that I have created. Before I get much further - I wanted to make sure that I am building my tables correctly

I have also attached a PDF file of what the final form I am trying to create is supposed to look like. Each instructor will enter in the student information, their attendance, as well as the grades. I need to have the attendance and grades total for them automatically.
Attendance will be the total of the "A"s (absent) and the total number will be in the "Att" field. Grades will be the average of Shop, Math, BP for each class (Total will be in "Train Avg" field)

Before I move onto the form - I want to make sure that my tables are set up properly now.
thank you

sampledb2.accdb
Students.pdf
amyamoAsked:
Who is Participating?
 
derekkrommCommented:
looks perfect
0
 
amyamoAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.