...
- The Notes entity contains a student identifier (pidm). This means that the whole notes feature is built to record notes concerning students, and not any other types of MIT person. Also means that a note is associated with one and only one student. A student, of course, could have zero or more notes.
- There is no direct association between a note and a person in any particular role (e.g. Advisor). The business rules around who can create and view notes should be implemented in code. This will give us the flexibility to use the notes feature in multiple applications, where the people creating and updating notes won't necessarily be an advisor - could be a department admin or instructor, for example.
- We will record who created the note and who last modified it.
- The Domain entity is intended to be the same as is used in the rules engine.
- It's not clear what the History entity will do - I think the intent is to track changes to notes.
- As of 1/16/2013, the ERD needs to be changed to refer to Notes rather than Comments.
Prototype/Demo
A simple prototype web app to be used as a demo now exists. The app is described here.