Ridgewater classes
UNF:
class(classId*	Class#	Sec	ClassTitle	Cr	Enr	Max	MeetingDates	Days	Time	Bldg	Rm	Instructor	Footnote)

Class# is the dept code plus number, broken up into dept.code and course.courseNumber.
ClassTitle became courseTitle.
Cr is crMin-crMax
MeetingDates became classDateBegin and classDateEnd with meetingDate for each actual meeting.
The Days is calculated so it need not be stored.
Time became meetingBegin and meetingEnd.
Bldg and Rm became rmId.
Instructor became instructorId.

bldg(bldgId*, bldgCode, bldgName)
class(classId*, courseId@, sec, enr, max, footnote, online)
class_dates(classId*, classDateBegin*, classDateEnd*)
class_instructor(classId*@, instructorId*@)
class_meeting(classId*@, meetingDate*, meetingBegin, meetingEnd, rmId@, instructorId*@)
course(courseId*, deptId@, courseNumber, courseTitle, crMin, crMax, studentMax)
dept(deptId*, code, name)
instructor(instructorId*, instructorFirstName, instructorLastName)
rm(rmId*, rmNumber, bldgId@)

OFF CAMPUS
If the rmId is null and not online then the class is OFF CAMPUS.
WHERE online = false AND rnID IS NULL