This is the dataset which should be used for homework 1 (Database course, University of Chicago).

UniversitySchemaDBUchicago

group: university schema
description[[ the data for homework 1, exercise 6.10

* the relation _course_ courses at the university
* the relation _takes_ which coures a student takes
* the relation _stuent_ students
* the relation _instructor_ instructors

]]

course = { course_id, title, dept_name, credits
  BIO-101, Intro_to_Biology, Biology, 4
  BIO-301, Genetics,  Biology, 4
  BIO-399, Computional_Biology, Biology, 3
  CS-101 Intro_to_computer_science Computer_Science 4
  HIS-100 Ancient_Greece History 1
  HIS-102 Ancient_Egypt History 2
}
    
takes = { ID course_id sec_id semester year grade
  00128 CS-101 1 Winter 2009 A
  19991 HIS-100 2 Spring 2010 B
  19991 HIS-102 1 Spring 2008 A
  00000 CS-101 1 Winter 2009 A
  00128 BIO-101 1 Spring 2010 A 
}

student = { ID name dept_name tot_cred
  00128 Zhang Biology 102
  12345 Shankar Computer_Science 32
  19991 Brandt History 80
  00000 Adam Computer_Science 100
}

instructor = {ID name dept_name salary 
10101 Srinivasan Computer_Science 6500
12121 Wu Finance 90000
15151 Mozart Music 40000
10000 Jackson Computer_Science 7000
20000 Vivaldi Music 10000
30000 Buffet Finance 100000
}