Problem structuring database for an assessment rubric app
So you'll have students with an primary id student_id. Assume courses have a primary id course_id.

So each course will have its own assessment as per the first column in the rubric.

 create table courses_info (
   course_id int unsigned not null,
   assessment_id int unsigned not null,
   assessment varchar(80) not null,
   primary key (course_id, assessment_id)
 )


Student assessments take student_id, course_id, assessment_id and store an assessment_result (assumed to be uniform over the entire institution):

 create table student_assessment (
   course_id int unsigned not null,
   assessment_id int unsigned not null,
   student_id int unsigned not null,
   assessment_result enum('Emergent',..., 'Excellent'),
   primary key (course_id, assessment_id, student_id)
 )


The rubric is the mapping between an assessment_id for each course_id with the learning_outcome being the element in the lookup table:

 create table rubric (
   course_id int unsigned not null,
   assessment_id int unsigned not null,
   assessment_result enum('Emergent',..., 'Excellent'),
   learning_outcomes text,
   primary key (course_id, assessment_id, assessment_result)
 )


To get the results you query and JOIN on the required columns: