You have been asked to design a database for the university administration, which records the following information: 1. All students necessarily have a unique student ID, a name, and a university email address. Each student is also either an undergraduate or a graduate student.
2. Each graduate student has an advisor.
3. Each undergraduate student has a major.
4. Students take courses. A student may take one course, multiple courses, or no courses.
5. Each course has a course number, course name, and days of the week the course is scheduled.
6. Each course has exactly one head TA, who is a graduate student.
Draw an ER diagram for this application. Decide the key attributes and identify them on the diagram. Be sure to indicate all key constraints. Please state all assumptions you make in your answers.