You have been asked to design a database for the university administration, which records the following information:
Fantastic news! We've Found the answer you've been seeking!
Question:
- 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.
- 7. Every head TA has an office where he or she holds office hours.
- Required: Draw an ER diagram for this application. Be sure to mark the multiplicity of each relationship of the diagram. Decide the key attributes and identify them on the diagram. Please state all assumptions you make in your answers.
Related Book For
Posted Date: