Based on the following ERD (see Figure) what the following statement represents:

SELECT DISTINCT takes.ID FROM takes, instructor, teaches WHERE takes. course_id = teaches.course_id AND takes.sec_id = teaches.sec_id AND takes.semester = teaches.semester AND takes.year = teaches.year AND teaches.id = instructor.id AND instructor.name = 'Einstein'

Select one: a. List of non-repetitive student IDs taught by instructor Einstein b. List of non-repetitive course IDs taught by instructor Einstein c. List of student IDs taught by instructor Einstein d. List of course IDs taught by instructor Einstein

-----------------------------------------------

Given the relation grade_points (grade, points) which enables a conversion of the evaluation in letters (A, B, C, etc.) from the relation takes in numerical evaluation: eg a grade "A" corresponds to the evaluation with 4 points, "A - "at 3.7 points," B + "at 3.3 points," B "at 3 points and so on. Grade points earned by a student for a course offered are defined as the product of the number of credits for the subject with numerical points for the grade the student receives.

Based on the above report and the university database (figure below) what report represents the following statement SELECT SUM (credits * points) FROM takes, course, grade_points WHERE takes.grade = grade_points.grade AND takes.course_id = course.course_id AND ID = "12345"

Select one: a. Report of total points (grade points) received by the student with ID 12345, for all courses he has attended b. The ratio of total points (grade points) received by students, for all courses they have attended c. The ratio of points (grade points) received by the student with ID 12345, for a course he has attended d. None of the alternatives e. Report of points (grades points) received by the student with ID 12345, for all courses he has attended

takes ID course id serid semester year grade student ID name depl_name tol_cred section course id advisor course course id title depr_name credits semester department dent name building budget i_id building room_number time_slor_id time_slot time_slor_id day start time end_time prereq course id classroom building room_number capacity instructor ID name dept name salary teaches ID course_id sec ld semester wear