Question: The University is wants to develop a database to keep track of its faculty, students, departments, students' major, and courses. Students can have undeclared major

The University is wants to develop a database to keep track of its faculty, students, departments, students' major, and courses. Students can have undeclared major (in which case they have no major), single major, or a double major (i.e. two majors). Departments offer many majors, and its possible for multiple departments to offer a single major jointly. Faculty can work more than department while a department employs many faculty. Faculty teach several courses which students are enrolled in. These courses are offered by individual departments. There is also a requirement that the database keep track of the student ID number, students year, and facultys research area. Draw a class (UML) diagram for the desired database.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!