SLC Course Database Schema Author: John McTeague Version: 1.0 Simple schema based on existing DB schema Top level element for describing a higher education institution. The high level institution details are common across all academic years. Element representing a course at an institution. Each course can be run over multiple academic years, for multiple years of study within that academic year, and within that year there may be multiple terms. Element representing a course at an institution. Each course can be run over multiple academic years, for multiple years of study within that academic year, and within that year there may be multiple terms. Information about a course that varies year on year A term has a number, start and end dates. Note that the campus element identifies the location at which the course term takes place and must refer to a pre-existing location entity. Information about an institution that can vary year on year A location for an institution. Does not vary year on year, is simply active or not. There should only be one location that is primary A qualification that is attained as a result of successfully attending a course.