Question 1:

A: Give 5 informal queries and 5 updates that you would expect to apply to the database shown in Figure 1.2.

B: Give 2 additional views that may be needed by other user groups for the database shown in Figure 1.2

C: Give 5 examples of integrity constraints that you think should hold on the database shown in Figure 1.2.

C:

STUDENT COURSE SECTION GRADE_REPORT PREREQUISITE Figure 1.2 A database that stores student and course information