class ( ClassId, Class #, Sec, Class Title, Cr, Enr, Max, Meeting Dates, Days, Time, Bldg, Rm, Instructor, Footnotes )

class ( ClassId, ClassNum, Sec, ClassTitle, Cr, Enr, Max, MeetingDates, Days, Time, Bldg, Rm, Instructor, Footnotes )

000729, CST1021, 42, HTML and CSS, 3, 0, 25, 08/26/19 - 12//19, , Arranged, ON, Online, Martinson, James, 
000729, CST1021, 42, HTML and CSS, 3, 0, 25, 08/26/19 - 12//19, W, 9:00am-11:30am, B, 48, Martinson, James, 
000729, CST1021, 42, HTML and CSS, 3, 0, 25, 08/26/19 - 12//19, W, 9:00am-11:30am, MAINHU, 327, Martinson, James, 

000739, CST1072, 41, Win Workstation Support, 3, 1, 24, 08/26/19 - 12//19, , Arranged, ON, Online, Hyberger, Mark, 
000739, CST1072, 41, Win Workstation Support, 3, 1, 24, 08/26/19 - 12//19, M, 9:00am-11:30am, B, 46, Hyberger, Mark, 
000739, CST1072, 41, Win Workstation Support, 3, 1, 24, 08/26/19 - 12//19, M, 9:00am-11:30am, MAINHU, 321, Hyberger, Mark

canidate keys ClassId, ClassNum & Sec, Sec ClassTitle
PK ClassId

MeetingDates = DateBegin, DateEnd
Time = TimeBegin, TimeEnd
Days = Day

class ( ClassId*, ClassNum@, Sec, Enr, Max, Footnotes )
course ( ClassNum*, ClassTitle, Cr )
meeting ( meetingId*, ClassId@, DateBegin, DateEnd, TimeBegin, TimeEnd, instructorId@ )
meetingdays ( meetingId*@, dayId*@ )
meetingrooms ( meetingId*@, roomId*@ )
day ( dayId*, Day )
campus ( campusId*, name )
bldg ( bldgId*, campusId@, Bldg )
room ( roomId*, bldgId@, Rm )
instructor ( instructorId*, Instructor )


Data in tables:

class ( ClassId*, courseId@, Sec, Enr, Max, Footnotes, Online )
        000729,           1, 42,  0,   25,  ,          yes
		000739,           2, 41,  1,   24,  ,          yes    
		
course ( courseId^, ClassNum*, ClassTitle,              Cr )
                1, CST1021,   HTML and CSS,            3
				2, CST1072,   Win Workstation Support, 3
				
meeting ( meetingId*, ClassId@, DateBegin, DateEnd,  TimeBegin, TimeEnd, instructorId@ )
                  1,    000729, 08/26/19,  12/20/19, ,          ,        1
                  2,    000729, 08/26/19,  12/20/19, 9:00am,   11:30am,  1
                  3,    000729, 08/26/19,  12/20/19, 9:00am,   11:30am,  1
                  4,    000739, 08/26/19,  12/20/19, ,          ,        2
                  5,    000739, 08/26/19,  12/20/19, 9:00am,   11:30am,  2
                  6,    000739, 08/26/19,  12/20/19, 9:00am,   11:30am,  2
				  
meetingdays ( meetingId*@, day[day.dayId]*@ )
                      2,   4
                      3,   4
                      5,   2
                      6,   2
					  
meetingrooms ( meetingId*@, roomId*@ )
                       2,   2
                       3,   1
                       5,   3
                       6,   4

day ( dayId*, Day )
      1,      U
      2,      M
      3,      T
      4,      W
      5,      H
      6,      f
      7,      S
	  
campus ( campusId*, name )
                1,  Hutchinson
				2,  Willmar
				
bldg ( bldgId*, campusId@, Bldg )
            1,  1,         MAINHU
			2,  2,         B
			
room ( roomId*, bldgId@, Rm )
            1,       1,  327
			2,       2,  48
			3,       2,  46
			4,       1,  321
			
instructor ( instructorId*, Instructor )
                        1,  Martinson, James
						2,  Hyberger, Rocky