students results table (1 Viewer)

[and1_hotsauce]

Hi
I have created a students results table below. Can I normalise the Reults table even further? Is this necessary?


http://i52.tinypic.com/amqj4i.png

http://i53.tinypic.com/2qmi4qc.png

 

[PNGBill]

tblCourseInfo
Primary Key should be CourseNumber - typo?

Careful with field name Results (Result is a reserved word)
suggest StudentResult, StudentGrade, StudentPassword StudPassword etc. It is safer to use two words for field names.

If tblCourseInfo is a general table listing all courses available, you should have another table that holds data of which student took what course when.

tblResults would then refer to the new table although you could have a table with the tests to be graded for each subject or this info could be with tblCourseInfo and tblResults creates a record for each student/test combination.

I would allow each table to have it's own autonumber primary key and then have a field names instead of the combined primary key in tblResults.
You can still avoid duplicates.

You appear to have the general idea just may need more tables IMO