Skip to main content

HESA Student Record 2007/08

Back to C07051

HESA Student Record 2007/08

Data model


return to index

Version 1.1 Produced 2007-10-19

The HESA student record specification is based on a data model which defines the entities covered by the record and the relationship between these entities.

HESA Student Record entity relationship diagram

Click on the relavant section of the model to view the fields associated with each entity.

Student Data ModelInstitutionStudentInstanceCourseEntry ProfileQualifications on EntryQualifications AwardedStudent on ModuleModule

Key :

One to many icon

One-to-many relationship

Optional icon

Optional participation of the entity in this relationship

Optional icon

Mandatory participation of the entity in this relationship

Relationship Definitions

Entities

Relationship

Institution to StudentAn Institution must have one or many Students
A Student must belong to an Institution
Student to InstanceA Student must have one or many Student Instances
A Student Instance must belong to a Student
Course to InstanceAn Instance must belong to one Course
A Course can have zero, one or many Student Instances
Instance to Entry ProfileAn Instance can have zero or one Entry Profiles
Entry Profile is compulsory during the first year of an Instance
An Entry Profile must belong to one Instance
Entry Profile to Qualifications on EntryAn Entry Profile can have zero, one or many Qualifications on Entry
A Qualification on Entry must belong to one Entry Profile
Instance to Qualification AwardedAn Instance can have zero, one or many Qualifications Awarded
A Qualification Awarded must belong to one Instance
Instance to Student on ModuleAn Instance can have zero, one or many occurrences of Student on Module
A Student on Module must belong to one Instance
Module to Student on ModuleA Student on Module must belong to one Module
A Module can have zero, one or many Students on Module

Contact Liaison by email or on 01242 211144.