| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1600/Resources/Week/15/ |
Upload File : |
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