Question

1. Add the following records to the teach table. The teach table determines which professor taught which course for the specified semester. Refer to Project 1 to determine what fields are in the teach table.
   1. 1, 101, 2, Fall 2021, St. Vincent, 115
   2. 2, 102, 3, Spring 2021, Dunleavy, 122
   3. 3, 101, 1, Spring 2021, St. Vincent, 104
   4. 4, 201, 7, Fall 2018, Depaul, 14
   5. 5, 201, 7, Fall 2021, Depaul, 30
   6. 6, 301, 6, Spring 2021, Dunleavy, 208
   7. 7, 301, 5, Fall 2021, Dunleavy, 305

Answer 1

a. INSERT INTO teach VALUES (1,101,2,'Fall 2021','St. Vincet',115);

b. INSERT INTO teach VALUES (2,102,3,'Spring 2021','Dunleavy',122);

c. INSERT INTO teach VALUES (3,101,1,'Spring 2021','St. Vincent',104);

d. INSERT INTO teach VALUES (4,201,7,'Fall 2018','Depaul',14);

e. INSERT INTO teach VALUES (5,201,7,'Fall 2021','Depaul',30);

f. INSERT INTO teach VALUES (6,301,6,'Spring 2021','Dunleavy',208);

g. INSERT INTO teach VALUES (7,301,5,'Fall 2021','Dunleavy',305);