Database Description. Suppose you are given the following database for keeping track of grades in this course. The data model from Homework #1 is significantly simplified where all gradable items (hw,quiz, exams) are combined into a single relation. Similarly all grades are also combined into a single relation) students(rin, fname, lname, email, optin date, optout date) gradables(gid, gtype, label, given date, duedate, maxgrade, points, nextg-id) grades(rin, gid, submission date, grade) Each student may have an opt-in date, if there is no date (i.e. the value is NULL) then the homeworks are optional for this student. If there is an opt-in date and no opt-out date, then homeworks are required. If there are dates for both opt-in and opt-out, only the homeworks that have a due date within within the given dates are required All gradable assignments are stored in gradables. The gtype is one of 'quiz', 'hw', 'exam' 'finalexam'. The label is the name given to the gradable as a string such as 'Hw 1' or 'Exam 2' If the gradable is a homework, we store the gid of the exam that it is directly before in nextg-id. All grades are stored in grades which stores the grade for each student. All date fields are formatted as mon-day-year, e.g. 01-31-2016 Database Description. Suppose you are given the following database for keeping track of grades in this course. The data model from Homework #1 is significantly simplified where all gradable items (hw,quiz, exams) are combined into a single relation. Similarly all grades are also combined into a single relation) students(rin, fname, lname, email, optin date, optout date) gradables(gid, gtype, label, given date, duedate, maxgrade, points, nextg-id) grades(rin, gid, submission date, grade) Each student may have an opt-in date, if there is no date (i.e. the value is NULL) then the homeworks are optional for this student. If there is an opt-in date and no opt-out date, then homeworks are required. If there are dates for both opt-in and opt-out, only the homeworks that have a due date within within the given dates are required All gradable assignments are stored in gradables. The gtype is one of 'quiz', 'hw', 'exam' 'finalexam'. The label is the name given to the gradable as a string such as 'Hw 1' or 'Exam 2' If the gradable is a homework, we store the gid of the exam that it is directly before in nextg-id. All grades are stored in grades which stores the grade for each student. All date fields are formatted as mon-day-year, e.g. 01-31-2016
