Assignment 01 Consider the following figure "Figure 01" that shows a schema of a database, study it well then answer its followed questions: STUDENT Name Student_number Class Major COURSE Course_name Course_number Credit_hours Department PREREQUISITE Course_number Prerequisite_number SECTION Section_identifier Course_number Semester Year Instructor GRADE_REPORT Student_number Section_identifier Grade Figure 01 1. Identify the primary key of each table. 2. Identify all the possible foreign keys. 3. Write relational algebra statements to performs the following: a. Retrieve the names of all the courses in the "CSE" department. b. Retrieve the names and the prerequisite number of all the courses in the "CSE" department. c. Retrieve the number of courses offered in the first semester of the year 2020. d. Retrieve the student name and his grades average. e. Retrieve the student name and his grades average in each semester.