List of classes :

Person :

Holds the information of an individual user.

Name
Type
Description
id key Primary key
username String  
forname String  
surname String  
password String  
dateCreation Date  
dateConfirmation Date  
lastLogin Date  

Link with :

 

Email :

Email address(es) of an user.

Name
Type
Description
id key Primary key
address String  

Link with :

Phone :

Phone number(s) of an user.

Name
Type
Description
id key Primary key
number String  

Link with :

Suspension :

Suspension of an user account.

Name
Type
Description
id key Primary key
suspensionDate Date Date suspension began
reason String  

Link with :

 

PersonStatus :

Represent the status of an user (staff, student, external actor or admin).

Name
Type
Description
id key Primary key
name String (Student,Staff,External actor,Admin)

Link with :

Organisation :

Organisation from wich come the external actor.

Name
Type
Description
id key Primary key
name String  
postalAdress String  
postcode String  
activity String

What the organisation does.

Link with :

Cohort :

Hold the Cohort informations.

Name
Type
Description
id key Primary key
Title String  
RegisterStart Date Date when registration can start
RegisterStop Date Last date for registration
ProjectStart Date Date when work should start on the project. This will normally be the first day of the relevant term/semester.
ProjectStop Date

Date when project final assessment should be submitted. (Note, marking and feedback will take place after this date.)

Link with :

ProjectIdea :

Idea of a project submitted by an user.

Name
Type
Description
id key Primary key
title String  
description String  
aims String aim and objectives of the project
academicQuestion String Academic question to be answered
submissionDate Date When someone has submitted this idea.
numberOfStudents int The number of students wich can participate to the project.

Link with :

FinalProject:

The final project after approvation. For more informations, we have to reffer to the ProjectIdea.

Name
Type
Description
id key Primary key
title String  
plannedSubmissionDate Date Date on which the final assessment artefact for the project is expected to be submitted (should be the same for all projects in the same cohort)
actualSubmissionDate Date Date/time when the final assessment artefact is actually submitted

Link with :

StudentNumber :

Id of the student in the university.

Name
Type
Description
id key Primary key
hemis String  

Link with :

 

IdeaStatus :

Status of an idea. An idea can be approved, provisionnal or withdrawn.

Name
Type
Description
id key Primary key
statusName String
  • Approved
  • Provisional
  • Withdrawn

Link with :

IdeaKind :

The different kinds of an idea.

Name
Type
Description
id key Primary key
name String

The name of the category, viz:

  • Engineering
  • Study
  • Multi (several students could do it independently)
  • Group (suitable for a group of students to do)

Link with :

 

ProjectIdeaHistory :

Represent the differents actions we can to do on the project ideas.

Name
Type
Description
id key Primary key
date Date Represent the date of the modification of the idea.
change String What has been changed
reason String Why the idea has been altered.

Link with :