E-R Diagram

. Each student is identified by a unique student id, a name, a date of birth, a GPA, and a unique email address. Each professor is identified by a unique id, a name, a social security number, and a unique email address. The courses are identified by a course number, a section number, and the semester they are taught. Besides, the course title and credit hours need to record. The professor must teach certain courses each semester. Each course is taught by one professor. Each course has a grading schema. The grading schema documents the relation of the cutoff (i.e., 90, 86.67, 83.34, 80, etc.) and the letter grade (i.e., A, A, A-, B+, B, etc.) Students are enrolled in several courses. Students receive a course grade for each of their enrolled courses. Each course has several students. Each course is taught by one professor has a set of grading categories with weight (i.e., Labs 25%, Project 35%, etc.). The weights of all the grading categories of a course add up to 100. Each category consists of several activities (i.e., Lab 1, Lab 2, etc.). Each of the activates has a title and a maximum available point (i.e., 100)