Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions