1.virtualcollege>BEGIN WORK;
2.virtualcollege>BEGIN
3.virtualcollege>LOCK TABLE sit_list IN ACCESS EXCLUSIVE MODE;
4.virtualcollege>LOCK TABLE
5.virtualcollege>SELECT students.student_id FROM students WHERE students.ssn = '999-99-9999';
6.virtualcollege>2
7.virtualcollege>SELECT catalog.course_id FROM catalog WHERE catalog.course_code = 'CIS-115';
8.virtualcollege>4
9.virtualcollege>SELECT class_list.class_id FROM class_list WHERE class_list.course_id = 4;
10.virtualcollege>12
11.virtualcollege>SELECT COUNT(sit_list.student_id) FROM sit_list WHERE sit_list.class_id = 12;
12.virtualcollege>10
13.virtualcollege>select class_list.sit_limit from class_list where class_list.class_id = 12;
14.virtualcollege>16
15.virtualcollege>"SELECT COUNT(class_id) FROM sit_list WHERE student_id = 2 AND class_id = 12;
16.virtualcollege>0
17.virtualcollege>INSERT INTO sit_list VALUES (12, 2);
18.virtualcollege>insert 1234 1
19.virtualcollege>INSERT INTO registration_list (student_id, notes, time_stamp) VALUES (2, 'notes', 'Feb, 12 2003 12:23:45 UT' );
20.virtualcollege>insert 1235 1
21.virtualcollege>COMMIT WORK;
22.virtualcollege>COMMIT