Courses are offered as sections $($SECTION$).$

m Each section is related to a single course and a single instructor and has

a unique section identifier $($SecId$).$

m A section also has a section number $($SecNo: this is coded as $1,2,3,...$

for multiple sections offered during the same semester$/$year$),$ semester

$($Sem$),$ year$($Year$),$ classroom $($CRoom: this is coded as a combination of

building code$($Bldg$)$ and room number $($RoomNo$)$ within the building$),$ and

days$/$times $($DaysTime: for example, $$MWF $9$am$-9\mathrm{.}50$am$$ or $$TR $3\mathrm{.}30$pm$-$

$5\mathrm{.}20$pm$$restricted to only allowed days$/$time values$).$

m The database will keep track of all the sections offered for the past

several years, in addition to the current offerings. The SecId is unique

for all sections, not just the sections for a particular semester.