College Database

Demos
Data Model Queries
Student
stno name addr city state zip
5571 lewis_Jerry 1 Main Rd providence ri 02904
2415 grogan_A_Mary 8 Walnut St. malden ma 02148
2661 mixon_Leatha 100 School St brookline ma 02146
2890 mcLane_Sandy 30 Cass Rd boston ma 02122
3442 novak_Roland 42 Beacon St nashua nh 03060
3566 pierce_Richard 70 Park St. brookline ma 02146
1011 edwards_P_David 10 Red Rd newton ma 02159
4022 prior_Lorraine 8 Beacon St boston ma 02125
5544 rawlings_Jerry 15 Pleasant Dr boston ma 02115

Advising/

Courses

stno empno
1011 019
2415 019
2661 023
2890 023
3442 056
3566 126
4022 234
5544 023
5571 234
cno name credit
cs110 introduction_to_Computing 4
cs210 computer_Programming 4
cs240 computer_Architecture 3
cs310 data_Structures 3
cs350 higher_Level_Languages 3
cs410 software_Engineering 3
cs460 graphics 3

 
 
Instructor
empno name rank roomno telno
019 evans_Robert professor 82 7122
023 exxon_George professor 90 9101
056 sawyer_Kathy assoc_Prof 91 5110
126 davis_William assoc_Prof 72 5411
234 will_Samuel assist_Prof 90 7024
Grades
stno empno cno sem year grade
1011 019 cs110 fall 91 40
2661 019 cs110 fall 91 80
3566 019 cs110 fall 91 95
5544 019 cs110 fall 91 100
1011 023 cs110 spring 92 75
4022 023 cs110 spring 92 60
3566 019 cs240 spring 92 100
5571 019 cs240 spring 92 50
2415 019 cs240 spring 92 100
3442 234 cs410 spring 92 60
5571 234 cs410 spring 92 80
1011 019 cs210 fall 92 90
2661 019 cs210 fall 92 70
3566 019 cs210 fall 92 90
5571 019 cs210 spring 93 85
4022 019 cs210 spring 93 70
5544 056 cs240 spring 93 70
1011 056 cs240 spring 93 90
4022 056 cs240 spring 93 80
2661 234 cs310 spring 93 100
4022 234 cs310 spring 93 75