Schema restricts a course name to a single course description

[afig]

Gradebook's schema has Name and Description of as part of one entity, Course. A course name is something like 'CS305' and a course description is something like 'Database Application Engineering'. Since they are attributes of the same entity, only one description can be associated with each course name. This setup cannot be used in most environments, including with the sample OpenClose data from WCSU. This is because:

• The description for a particular course can change over time
• The description can differ for different sections of the same course, even within the same term

These two situations often occur in "faculty-developed" and "independent study" courses. In the OpenClose data, these usually have course names that end with 98 or 99, respectively.

One possible solution is to have Description be a part of the Section entity. Further investigation would be needed to investigate any potential side effects of doing so.