Complete the task and review the STUDENT database schema: STUDENT Database Schema 

 

Using the data in the STUDENT database, create a table named GRADE_HISTORY that contains the grade (NUMERIC_GRADE), grade_type_code, grade_code_occurrence in the GRADES table, the student ID, student name, section_ID, course_no, instructor_id and instructor name associated with the grade. 

 

Share your query with the class and discuss the technique(s) you used to create the table. (You can create interim tables as needed.) 

 

For example, the first thing you might want to do is determine how many rows there are in the GRADE table. The number of rows of GRADE_HISTORY will be the same as the number of rows in the GRADE table.