/* SCD - Slowly Changing Dimension - Type 2 - Course dimension */ 
/* When did the change in course department take effect?       */

select * from course;

select * from course where description='JavaScript';


/* Display all the grade facts associated with JavaScript  */

select description, course_num, department, full_date
from grade join course using(course_id)
           join dates  using(date_id)
where description='JavaScript'
order by date_id;