StudentDB.txt

group: Elmasri & Navathe StudentCourse DB Figure 1.2

description[[ the data for this dataset was taken from the Elmasri & Navathe (Fundamentals of Database Systems Textbook) with some minor modifications

The relation _Student_ contains basic information about a student	
The relation _Course_ contains basic information about a course
The relation _Section_ contains information the different course sections
The relation _Grade_report_ contains info on grades students received in the course
The relation _Prerequisite_ contains information on course Prerequesites
]]

Student = {
  Name, Student_number:number, Class:number, Major
  Smith, 17, 1, CS
  Brown, 8, 2, CS
}

Course = {
  Course_name, Course_number, Credit_hours:number, Department
  Intro-to-Computer-Science, CS1310, 4, CS
  Data-Structures, CS3320, 4, CS
  Discrete-Mathematics, MATH2410, 3, MATH
  Database, CS3380, 3, CS
}

Section = {
  Section_identifier:number, Course_number, Semester, Year, Instructor
  85, MATH2410, Fall, 07, King
  92, CS1310, Fall, 07, Anderson
  102, CS3320, Spring, 08, Knuth
  112, MATH2410, Fall, 08, Chang
  119, CS1310, Fall, 08, Anderson
  135, CS3380, Fall, 08, Stone
}

Grade_Report = {
  Student_number:number, Section_identifier:number, Grade
  17, 112, B
  17, 119, C
  8, 85, A
  8, 92, A
  8, 102, B
  8, 135, A
}

Prerequisite = {
  Course_number, Prerequisite_number
  CS3380, CS3320
  CS3380, MATH2410
  CS3320, CS1310
}