Changes from original Gradebook schema

Conceptual Schema

• Course entity
  • MOD: Change Description entity to Default Title
• Section entity
  • FIX: Change PK from CRN to ID
  • FIX: Add CRN as a non-key attribute
  • FIX: Add attributes Start Date and End Date
  • FIX: Remove Midterm Date (part of Term)
  • MOD: Add Title attribute 
• Term entity
  • ALT: Add midterm attribute
  • FIX: Change PK from {Year, Season} to ID
  • FIX: Add Year attribute
• Relationship between Enrollee, Assessment Component, and Assessment Item
  • ALT: Move relationship attributes that were between Enrollee and Unnamed into unnamed entity
  • ALT: Add name to entity formed by tertiary relationship (Assessment).
• Entity Student
  • FIX: Change Name to composite attribute that include f,m,l name
  • FIX: Add School Issued ID attribute
  • FIX: Add Email attribute
  • ALT: Make Major a multi-valued attribute
• Entity Enrollee
  • FIX: Add Enrollment Major and Enrollment Year attributes
  • FIX: Add Midterm Weighted Aggregate and Final Weighted Aggregate attributes
  • ALT: Change grades into 2 composite attributes
• FIX: Add Entity Attendance Status
  • FIX: Add PK Status
  • FIX: Add attribute Description
• Entity Attendance Record
  • FIX: Remove status attribute (part of Attendance Status)
• Entity Grade
  • FIX: Add attribute GPA
• Entity Instructor
  • FIX: Change name to a composite attribute containing f,m,l name

Other changes

• FIX: Kemerovo MajorEnrolled attribute from Enrollee?