Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
This is the dataset which should be used for homework 1 (Database course, University of Chicago).
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
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.