Sample Runs of Driver Programs (assignment 4)

ASCSC1PP629W1:solution raj$ python3 Driver5_RenameTimes.py
REL1(COL1:INTEGER,COL2:VARCHAR)
Number of tuples:5

1111:Robert Adams
1112:Charles Bailey
1114:Richard Johnson
1115:Graham Gooch
1116:John Miller

RENAMECOLS(NEWCOL1:INTEGER,NEWCOL2:VARCHAR)
Number of tuples:5

1111:Robert Adams
1112:Charles Bailey
1114:Richard Johnson
1115:Graham Gooch
1116:John Miller

REL1(COL1:INTEGER,COL2:VARCHAR)
Number of tuples:5

1111:Robert Adams
1112:Charles Bailey
1114:Richard Johnson
1115:Graham Gooch
1116:John Miller

REL2(COL1:INTEGER,COL2:VARCHAR)
Number of tuples:5

1113:John Smith
1112:Charles Bailey
1115:Graham Gooch
1116:John Miller
1117:Hugh Howell

R1TIMESR2(REL1.COL1:INTEGER,REL1.COL2:VARCHAR,REL2.COL1:INTEGER,REL2.COL2:VARCHAR)
Number of tuples:25

1111:Robert Adams:1113:John Smith
1111:Robert Adams:1112:Charles Bailey
1111:Robert Adams:1115:Graham Gooch
1111:Robert Adams:1116:John Miller
1111:Robert Adams:1117:Hugh Howell
1112:Charles Bailey:1113:John Smith
1112:Charles Bailey:1112:Charles Bailey
1112:Charles Bailey:1115:Graham Gooch
1112:Charles Bailey:1116:John Miller
1112:Charles Bailey:1117:Hugh Howell
1114:Richard Johnson:1113:John Smith
1114:Richard Johnson:1112:Charles Bailey
1114:Richard Johnson:1115:Graham Gooch
1114:Richard Johnson:1116:John Miller
1114:Richard Johnson:1117:Hugh Howell
1115:Graham Gooch:1113:John Smith
1115:Graham Gooch:1112:Charles Bailey
1115:Graham Gooch:1115:Graham Gooch
1115:Graham Gooch:1116:John Miller
1115:Graham Gooch:1117:Hugh Howell
1116:John Miller:1113:John Smith
1116:John Miller:1112:Charles Bailey
1116:John Miller:1115:Graham Gooch
1116:John Miller:1116:John Miller
1116:John Miller:1117:Hugh Howell

ASCSC1PP629W1:solution raj$ python3 Driver6_Project.py
STUDENT(SID:INTEGER,SNAME:VARCHAR,PHONE:INTEGER,MAJOR:VARCHAR,GPA:DECIMAL)
Number of tuples:4

1111:Robert Adams:1234:Computer Science:4.0
1112:Charles Bailey:5656:Computer Science:3.5
1113:David Beatle:1212:Mathematics:3.5
1114:Graham Gooch:5678:Computer Science:3.5

PROJECT_SID_GPA_STUDENT(SID:INTEGER,GPA:DECIMAL)
Number of tuples:4

1111:4.0
1112:3.5
1113:3.5
1114:3.5

PROJECT_MAJOR_GPA_STUDENT(MAJOR:VARCHAR,GPA:DECIMAL)
Number of tuples:3

Computer Science:4.0
Computer Science:3.5
Mathematics:3.5

PROJECT_MAJOR_STUDENT(MAJOR:VARCHAR)
Number of tuples:2

Computer Science
Mathematics

ASCSC1PP629W1:solution raj$ python3 Driver7_Select.py
STUDENT(SID:INTEGER,SNAME:VARCHAR,PHONE:INTEGER,MAJOR:VARCHAR,GPA:DECIMAL)
Number of tuples:4

1111:Robert Adams:1234:Computer Science:4.0
1112:Charles Bailey:5656:Computer Science:3.5
1113:David Beatle:1212:Mathematics:3.5
1114:Graham Gooch:5678:Computer Science:3.5

SELECT_SID_=_1114(SID:INTEGER,SNAME:VARCHAR,PHONE:INTEGER,MAJOR:VARCHAR,GPA:DECIMAL)
Number of tuples:1

1114:Graham Gooch:5678:Computer Science:3.5

SELECT_GPA_>_3.5(SID:INTEGER,SNAME:VARCHAR,PHONE:INTEGER,MAJOR:VARCHAR,GPA:DECIMAL)
Number of tuples:1

1111:Robert Adams:1234:Computer Science:4.0

SELECT_MAJOR_=_Computer Science(SID:INTEGER,SNAME:VARCHAR,PHONE:INTEGER,MAJOR:VARCHAR,GPA:DECIMAL)
Number of tuples:3

1111:Robert Adams:1234:Computer Science:4.0
1112:Charles Bailey:5656:Computer Science:3.5
1114:Graham Gooch:5678:Computer Science:3.5

ASCSC1PP629W1:solution raj$ python3 Driver8_JoinA.py
STUDENT(SID:INTEGER,SNAME:VARCHAR,PHONE:INTEGER,MAJOR:VARCHAR,GPA:DECIMAL)
Number of tuples:4

1111:Robert Adams:1234:Computer Science:4.0
1112:Charles Bailey:5656:Computer Science:3.5
1113:David Beatle:1212:Mathematics:3.5
1114:Graham Gooch:5678:Computer Science:3.5

ENROLL(SID:INTEGER,COURSE:VARCHAR,GRADE:VARCHAR)
Number of tuples:3

1111:Database Systems:A
1114:Database Systems:B
1114:Java Programming:A

STUDENT_JOIN_ENROLL(SID:INTEGER,SNAME:VARCHAR,PHONE:INTEGER,MAJOR:VARCHAR,GPA:DECIMAL,COURSE:VARCHAR,GRADE:VARCHAR)
Number of tuples:3

1111:Robert Adams:1234:Computer Science:4.0:Database Systems:A
1114:Graham Gooch:5678:Computer Science:3.5:Database Systems:B
1114:Graham Gooch:5678:Computer Science:3.5:Java Programming:A

ASCSC1PP629W1:solution raj$ python3 Driver8_JoinB.py
STUDENT(SID:INTEGER,SNAME:VARCHAR,PHONE:INTEGER,MAJOR:VARCHAR,GPA:DECIMAL)
Number of tuples:4

1111:Robert Adams:1234:Computer Science:4.0
1112:Charles Bailey:5656:Computer Science:3.5
1113:David Beatle:1212:Mathematics:3.5
1114:Graham Gooch:5678:Computer Science:3.5

ENROLL(SID:INTEGER,COURSE:VARCHAR,GRADE:VARCHAR)
Number of tuples:3

1111:CSC 4710:A
1114:CSC 2310:B
1114:CSC 2310:A

COURSES(COURSE:VARCHAR,TITLE:VARCHAR,CREDITS:INTEGER)
Number of tuples:3

CSC 4710:Database Systems:4
CSC 2010:Java I:3
CSC 2310:Java II:3

ANSWER(SNAME:VARCHAR)
Number of tuples:1

Robert Adams