## School: students, courses, enrollments and grades
Student @Students order="lastName"
   <filter name="lastName" property="lastName" display="primary" />
   <filter name="grade" property="gradeLevel" display="primary" />
   firstName d r / lastName d r
   studentNumber ds r
   birthDate date r
   gradeLevel GradeLevel ds r
   guardian Guardian
   <embeddedlisting name="enrollments" entity="Enrollment" subset="forStudent" subsetparams="." defaultset="newForStudent" defaultsetparams="." />

Guardian @Students order="lastName"
   firstName d r / lastName d r
   phone r
   email

GradeLevel @Configuration order="position"
   name d r
   position integer r

Teacher @Staff order="lastName"
   firstName d r / lastName d r
   email r

Course @Academic order="name"
   <subset name="forGradeLevel" order="name">
   <param name="gradeLevel" entity="GradeLevel" />
   <condition field="gradeLevel" value="gradeLevel" />
   </subset>
   name d r
   gradeLevel GradeLevel ds r
   teacher Teacher ds
   capacity integer
   enrolledCount integer ds formula="(SELECT COUNT(*) FROM enrollment WHERE enrollment.course = id)"

Enrollment @Academic order="id desc"
   <subset name="forStudent" order="id desc">
   <param name="student" entity="Student" />
   <condition field="student" value="student" />
   </subset>
   <defaultset name="newForStudent">
   <param name="student" entity="Student" />
   <default name="student" value="student" />
   <default name="gradeLevel" value="student.gradeLevel" />
   </defaultset>
   <action name="grade" label="Record grades" type="relatedentity" entity="RecordGrades" location="listing" defaultset="forEnrollments" />
   student Student d r
   gradeLevel GradeLevel transient hidden
   course Course d r subset="forGradeLevel" subsetparams="gradeLevel"
   enrolledOn date ds default="now"
   finalGrade double ds
   passed boolean ds calculated="finalGrade >= 6"

RecordGrades @ transient
   <defaultset name="forEnrollments">
   <param name="enrollments" entity="Enrollment" collection="set" />
   <default name="enrollments" value="enrollments" />
   </defaultset>
   enrollments Enrollment set fixed
   finalGrade double r