Ex_Teaching

scalation.database.relation.Ex_Teaching
object Ex_Teaching

The Ex_Teaching object contains table definitions for the TASchedule app.

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Self type

Members list

Value members

Concrete fields

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

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 course-section table - for 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 course-section table - for 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

val ta: Relation

The teaching assistants table. lname: last name of TA fname: first name of TA level: MS 0, PhD 1, IoR 2, GSRA 3 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 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 course 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 course 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