ER Diagram

Registration System You are required to develop a registration system for a university. The system should keep track of students' record; this includes the courses they have finished and their grades, and current courses as well as student's personal data, which include ID, name, gender, mobile, birth date, department, major, and nationality. Each semester, the university offers many courses through the departments, where each department belongs to a college. Each course has a unique code, name, number of credit hours in addition to prerequisites; the course might have maximum three prerequisite courses. In order for a student to enroll in a course, he/she should pass the prerequisite course(s).The course is offered through different sections, each section has a code composed of the course code followed by underscore and section number, the section has a time, and a room. Each room has a unique code, a building code, and capacity. The system should not allow assigning a section to room it section's limit is greater than room's capacity, and not allow two sections to be timely overlapped in the same room. The section is taught by a specific instructor. Each instructor has a unique ID, name, and belong to a specific dept. Each section has a limit (max. number of students who can enroll in the section). A student can register up to 18 credit hours per semester. Student cannot register in a course that he/she already passed by grade other than "D" or "D+. In addition, a student cannot register if there is a hold on his/her record. It is important that the system should not allow timing overlapping between the courses that a student register. Students also can drop the courses that has no grade yet