he question of this part analyzes the students’ understanding in analyzing the given scenario and practical skills to build Class diagrams studied in chapters 8, 10 and 12 of IT242. The Department of Academic Advising at the College of Computing and Informatics (CCI) would desire to have a database system to keep track of students details such as study plans, college’s academic advisors, and counselling services. Read the following paragraph to answer the given question. In the proposed E-Counselling System (ECS), any academic advisor can advise from 20 to 25 students registered under his/her name. However, any student has only one academic advisor. In addition, any student can submit up to three complaints. Every submitted complaint by the student is assigned to one staff member to handle it until being resolved. Moreover, every staff member in the Department of Academic Advising can handle not more than 5 complaints. The academic advisor should conduct two meetings in each semester to all students assigned to him/her. However, the student should join at least one of the two meetings, otherwise, further actions will be taken. To organize an advising meeting, the academic advisor needs to determine the meeting details, such as date and time, and announce them to the students. Draw a Class Diagram for the given database. The diagram mu

Principles of Information Systems (MindTap Course List)
13th Edition
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter12: System Acquisition And Development
Section: Chapter Questions
Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...
icon
Related questions
Question

The question of this part analyzes the students’ understanding in analyzing the given scenario and practical skills to build Class diagrams studied in chapters 8, 10 and 12 of IT242.

The Department of Academic Advising at the College of Computing and Informatics (CCI) would desire to have a database system to keep track of students details such as study plans, college’s academic advisors, and counselling services. Read the following paragraph to answer the given question.

In the proposed E-Counselling System (ECS), any academic advisor can advise from 20 to 25 students registered under his/her name. However, any student has only one academic advisor. In addition, any student can submit up to three complaints. Every submitted complaint by the student is assigned to one staff member to handle it until being resolved. Moreover, every staff member in the Department of Academic Advising can handle not more than 5 complaints. The academic advisor should conduct two meetings in each semester to all students assigned to him/her. However, the student should join at least one of the two meetings, otherwise, further actions will be taken. To organize an advising meeting, the academic advisor needs to determine the meeting details, such as date and time, and announce them to the students.

Draw a Class Diagram for the given database. The diagram must show all classes, relationships between the classes, and the multiplicities.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Transaction Processing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning