Instructor ID 2 3 Instructor Instructor Name Department Name Salary Wang Wu Computer Science 65000 Finance 90000 4 Mozart Einstein Music 40000 Physics 95000 5 El Said History 60000 6 Gold Physics 87000 7 Katz Computer Science 75000 8 Califieri History 62000 9 Singh Finance 80000 10 Crick Biology 72000 11 Brandt Computer Science 92000 12 Kim Electrical Engineering 80000 Course Course ID Course Title Department Name Credits BIO-101 BIO-301 Introduction to Biology Biology 4 Genetics Biology 4 BIO-399 Computational Biology Biology 3 CS-101 Introduction to CS Computer Science 4 CS-190 Game Design Computer Science 4 CS-315 Robotics Computer Science 3 CS-319 Image Processing Computer Science 3 CS-347 Database System Computer Science 3 EE-181 Introduction to Digital System Electrical Engineering 3 FIN-201 Investment Banking Finance 3 HIS-351 World History History 3 MU-199 PHY-101 Music Video Production Music 3 Physical Principles Physics 4 Prereq Course ID Preq ID BIO-301 BIO-101 BIO-399 BIO-101 CS-190 CS-101 CS-315 CS-101 CS-319 CS-101 CS-101 NULL CS-347 CS-101 FF-181 PHY-101 Section Course ID BIO-101 Section ID 1 Semester Year Summer 2017 Classroom ID Time Slot ID 7 2 BIO-301 Summer 2018 7 1 CS-101 Fall 2017 1 8 CS-101 Spring 2018 6 CS 190 2018 6 5 CS-190 2 Fall 2018 6 1 CS-315 Fall 2017 3 4 CS-319 1 Spring 2018 2 2 CS-319 2 Spring 2018 4 3 CS-347 1 Fall 2017 5 1 EE-181 1 Spring 2018 6 3 FIN-201 I Spring 2017 8 2 HIS-351 1 Fall 2018 7 3 MU-199 1 Summer 2018 9 + PHY-101 Fall 2017 Instructor ID Course ID Teaches Section 10 Semester Year CS-101 1 Fall 2017 CS-315 1 Spring 2018 L CS-347 Fall 2017 2 3 FIN-201 MU-199 1 Spring 2017 Summer 2018 3 PHY-101 Fall 2017 5 HIS-351 Fall 2018 6 CS-101 Spring 2018 6 CS.119 1 Spring 2018 7 BIO-101 1 Summer 2017 7 BIO-301 1 Summer 2018 8 CS-190 Fall 2018 8 CS-190 2 2018 8 CS-319 2 Spring 2018 9 EE-181 11 Spring 2018 Student Student ID Student Name Department Name ப Johnson Computer Science 2 Jones Biology 3 Lindsay Computer Science 4 Smith History Takes Student ID Course ID Section ID Semester Year Grade CS-101 ப Fall 2017 A CS-190 2 Fall 2018 B+ CS-319 2 Spring 2018 A- 3 CS-319 Spring 2018 11 4 PHY-101 I Fall 2017 B+ 4 BIO-301 Summer 2018 C 2 CS-347 Fall 2017 A TimeSlot Time Slot ID Day Monday Start Time 9:30 AM End Time 11:00AM 2 Tuesday 10:30 AM 11:45 AM 3 Wednesday 5:30 PM 6:15 PM 4 Thursday 3:30 PM 4:20 PM 5 Friday 3:30 PM 4:20 PM 6 Thursday 8:30 AM 9:45 AM Department Department Name Building Biology A Budget 90000 Computer Science B 100000 Electrical Engineering B 15000 Finance C 120000 History c 50000 Music D 50000 Physics A 20000 Classroom Classroom ID Building Room Number Capacity A 101 40 12 A 105 50 3 A 110 45 4 A 310 35 5 B 310 40 6 B 317 55 7 C 301 40 8 D 101 20 9 D 110 30