TA_AssignmentDB

scalation.database.table.TA_AssignmentDB

The TA_AssignmentDB object contains table definitions for making TA Assignments.

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Self type

Members list

Value members

Concrete fields

val course: Table

The course table - for courses to be assigned TAs. dept: department code cno: course number (lab course 13011 means 1301L) title: course title

The course table - for courses to be assigned TAs. dept: department code cno: course number (lab course 13011 means 1301L) title: course title

Attributes

val i_pref: Table

The preferred teaching assistants per faculty member x course. ilname: instructor name cno: course number lname1: last name of TA - first choice lname2: last name of TA - second choice

The preferred teaching assistants per faculty member x course. ilname: instructor name cno: course number lname1: last name of TA - first choice lname2: last name of TA - second choice

Attributes

The schedule table - period to class time mapping period: the class period mwf: times for MWF classes tr: times for TR classes

The schedule table - period to class time mapping period: the class period mwf: times for MWF classes tr: times for TR classes

Attributes

val section: Table

The section table - for sections of courses to be assigned TAs. crn: course-section reference number cno: course number period1: main time periods period2: additional time periods ilname: name of the instructor seats: maximum enrollment avail: seats still available

The section table - for sections of courses to be assigned TAs. crn: course-section reference number cno: course number period1: main time periods period2: additional time periods ilname: name of the instructor seats: maximum enrollment avail: seats still available

Attributes

The section2 table - for sections of courses taken by TAs. crn: course-section reference number cno: course number period1: main time periods period2: additional time periods ilname: name of the instructor seats: maximum enrollment avail: seats still available

The section2 table - for sections of courses taken by TAs. crn: course-section reference number cno: course number period1: main time periods period2: additional time periods ilname: name of the instructor seats: maximum enrollment avail: seats still available

Attributes

val ta: Table

The teaching assistants table. lname: last name of TA fname: first name of TA level: MS 0, PhD 1, IoR 2, GSRA 3 labok: lab TA needs MS or 18 hours of graduate coursework (-1 => unknown, 0 => no, 1 => yes) tep: English Level 3, Level 4 hours: number of hours per week, e.g., 13.3 or 17.8

The teaching assistants table. lname: last name of TA fname: first name of TA level: MS 0, PhD 1, IoR 2, GSRA 3 labok: lab TA needs MS or 18 hours of graduate coursework (-1 => unknown, 0 => no, 1 => yes) tep: English Level 3, Level 4 hours: number of hours per week, e.g., 13.3 or 17.8

Attributes

The assignment of teaching assistants to courses (cno) / sections (crn) table. lname: last name of TA fname: first name of TA cno: course name crn: course-section reference number (-1 => delegated to instructor) hours: hours per week assigned the instructor-course ilname: instructor name

The assignment of teaching assistants to courses (cno) / sections (crn) table. lname: last name of TA fname: first name of TA cno: course name crn: course-section reference number (-1 => delegated to instructor) hours: hours per week assigned the instructor-course ilname: instructor name

Attributes

The class schdedule for the teaching assistants table. lname: last name of TA periods: the perioids for which the TA is taking classes 71,72,73,74,75,76,77,78,,1,2,3,4,5,6,7,8,9,10 cnos: the course numbers as string, e.g., "6370, 6470"

The class schdedule for the teaching assistants table. lname: last name of TA periods: the perioids for which the TA is taking classes 71,72,73,74,75,76,77,78,,1,2,3,4,5,6,7,8,9,10 cnos: the course numbers as string, e.g., "6370, 6470"

Attributes