Skip to content

Instantly share code, notes, and snippets.

@ssudarshaniitb

ssudarshaniitb/univdb7.txt

Created July 12, 2018 13:35
Show Gist options
  • Save ssudarshaniitb/2691536d491cbeba6a4665954a15e9c4 to your computer and use it in GitHub Desktop.
Save ssudarshaniitb/2691536d491cbeba6a4665954a15e9c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
univdb7.txt
- Dataset for the University database schema from
-- Database System Concepts by Silberschatz, Korth and Sudarshan
group: UniversityDB
classroom = {
building:string, room_number:number, capacity:number
Packard, 101, 500
Painter, 514, 10
Taylor, 3128, 70
Watson, 100, 30
Watson, 120, 50
}
department = {
dept_name:string, building:string, budget:number
Biology, Watson, 90000
'Comp. Sci.', Taylor, 100000
'Elec. Eng.', Taylor, 85000
Finance, Painter, 120000
History, Painter, 50000
Music, Packard, 80000
Physics, Watson, 70000
}
course={
course_id:string, title:string, dept_name:string, credits:number
BIO-101, 'Intro. to Biology', Biology, 4
BIO-301, Genetics, Biology, 4
BIO-399, 'Computational Biology', Biology, 3
CS-101, 'Intro. to Computer Science', 'Comp. Sci.', 4
CS-190, 'Game Design', 'Comp. Sci.', 4
CS-315, Robotics, 'Comp. Sci.', 3
CS-319, 'Image Processing', 'Comp. Sci.', 3
CS-347, 'Database System Concepts', 'Comp. Sci.', 3
EE-181, 'Intro. to Digital Systems', 'Elec. Eng.', 3
FIN-201, 'Investment Banking', Finance, 3
HIS-351, 'World History', History, 3
MU-199, 'Music Video Production', Music, 3
PHY-101, 'Physical Principles', Physics, 4
}
instructor ={
ID:number, name:string, dept_name:string, salary:number
10101, Srinivasan, 'Comp. Sci.', 65000
12121, Wu, Finance, 90000
15151, Mozart, Music, 40000
22222, Einstein, Physics, 95000
32343, 'El Said', History, 60000
33456, Gold, Physics, 87000
45565, Katz, 'Comp. Sci.', 75000
58583, Califieri, History, 62000
76543, Singh, Finance, 80000
76766, Crick, Biology, 72000
83821, Brandt, 'Comp. Sci.', 92000
98345, Kim, 'Elec. Eng.', 80000
}
section={
course_id:string, sec_id:number, semester:string, year:number, building:string, room_number:number, time_slot_id:string
BIO-101, 1, Summer, 2017, Painter, 514, B
BIO-301, 1, Summer, 2018, Painter, 514, A
CS-101, 1, Fall, 2017, Packard, 101, H
CS-101, 1, Spring, 2018, Packard, 101, F
CS-190, 1, Spring, 2017, Taylor, 3128, E
CS-190, 2, Spring, 2017, Taylor, 3128, A
CS-315, 1, Spring, 2018, Watson, 120, D
CS-319, 1, Spring, 2018, Watson, 100, B
CS-319, 2, Spring, 2018, Taylor, 3128, C
CS-347, 1, Fall, 2017, Taylor, 3128, A
EE-181, 1, Spring, 2017, Taylor, 3128, C
FIN-201, 1, Spring, 2018, Packard, 101, B
HIS-351, 1, Spring, 2018, Painter, 514, C
MU-199, 1, Spring, 2018, Packard, 101, D
PHY-101, 1, Fall, 2017, Watson, 100, A
}
teaches={
ID:number, course_id:string, sec_id:number, semester:string, year:number
10101, CS-101, 1, Fall, 2017
10101, CS-315, 1, Spring, 2018
10101, CS-347, 1, Fall, 2017
12121, FIN-201, 1, Spring, 2018
15151, MU-199, 1, Spring, 2018
22222, PHY-101, 1, Fall, 2017
32343, HIS-351, 1, Spring, 2018
45565, CS-101, 1, Spring, 2018
45565, CS-319, 1, Spring, 2018
76766, BIO-101, 1, Summer, 2017
76766, BIO-301, 1, Summer, 2018
83821, CS-190, 1, Spring, 2017
83821, CS-190, 2, Spring, 2017
83821, CS-319, 2, Spring, 2018
98345, EE-181, 1, Spring, 2017
}
student={
ID:number,name:string, dept_name:string,tot_cred:number
00128, Zhang, 'Comp. Sci.', 102
12345, Shankar, 'Comp. Sci.', 32
19991, Brandt, History, 80
23121, Chavez, Finance, 110
44553, Peltier, Physics, 56
45678, Levy, Physics, 46
54321, Williams, 'Comp. Sci.', 54
55739, Sanchez, Music, 38
70557, Snow, Physics, 0
76543, Brown, 'Comp. Sci.', 58
76653, Aoi, 'Elec. Eng.', 60
98765, Bourikas, 'Elec. Eng.', 98
98988, Tanaka, Biology, 120
}
takes={
ID:number, course_id:string, sec_id:number, semester:string, year:number, grade:string
00128, CS-101, 1, Fall, 2017, A
00128, CS-347, 1, Fall, 2017, 'A-'
12345, CS-101, 1, Fall, 2017, C
12345, CS-190, 2, Spring, 2017, A
12345, CS-315, 1, Spring, 2018, A
12345, CS-347, 1, Fall, 2017, A
19991, HIS-351, 1, Spring, 2018, B
23121, FIN-201, 1, Spring, 2018, 'C+'
44553, PHY-101, 1, Fall, 2017, 'B-'
45678, CS-101, 1, Fall, 2017, F
45678, CS-101, 1, Spring, 2018, 'B+'
45678, CS-319, 1, Spring, 2018, B
54321, CS-101, 1, Fall, 2017, 'A-'
54321, CS-190, 2, Spring, 2017, 'B+'
55739, MU-199, 1, Spring, 2018, 'A-'
76543, CS-101, 1, Fall, 2017, A
76543, CS-319, 2, Spring, 2018, A
76653, EE-181, 1, Spring, 2017, C
98765, CS-101, 1, Fall, 2017, 'C-'
98765, CS-315, 1, Spring, 2018, B
98988, BIO-101, 1, Summer, 2017, A
98988, BIO-301, 1, Summer, 2018, null
}
advisor={
s_id:number, i_id:number
00128, 45565
12345, 10101
23121, 76543
44553, 22222
45678, 22222
76543, 45565
76653, 98345
98765, 98345
98988, 76766
}
time_slot={
time_slot_id:string, day:string, start_hr:number, start_min:number, end_hr:number, end_min:number
A, M, 8, 0, 8, 50
A, W, 8, 0, 8, 50
A, F, 8, 0, 8, 50
B, M, 9, 0, 9, 50
B, W, 9, 0, 9, 50
B, F, 9, 0, 9, 50
C, M, 11, 0, 11, 50
C, W, 11, 0, 11, 50
C, F, 11, 0, 11, 50
D, M, 13, 0, 13, 50
D, W, 13, 0, 13, 50
D, F, 13, 0, 13, 50
E, T, 10, 30, 11, 45
E, R, 10, 30, 11, 45
F, T, 14, 30, 15, 45
F, R, 14, 30, 15, 45
G, M, 16, 0, 16, 50
G, W, 16, 0, 16, 50
G, F, 16, 0, 16, 50
H, W, 10, 0, 12, 30
}
prereq={
course_id:string, prereq_id:string
BIO-301, BIO-101
BIO-399, BIO-101
CS-190, CS-101
CS-315, CS-101
CS-319, CS-101
CS-347, CS-101
EE-181, PHY-101
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment