Department Of Software Engineering
Name: Hafiz Muhammad Abdul Mateen
Section: V
Semester: 5th
Sap: 70136502
Subject: Database System
Date: 23-October-2024
Submitted to: Sir shahid Saleem
Assignment No. 1
1. Proposal Requirements:
Project Title:
Student Counseling and Mental Health Database
Project Description:
This project aims to design and implement a database system that supports student counseling and
mental health services within a university. The database will store and manage data related to
counseling sessions, mental health assessments, student information, and counselor availability.
The goal is to streamline the workflow for counselors, ensure confidentiality of student records,
and provide detailed reporting on mental health trends. This system will significantly enhance the
efficiency of the counseling center, enabling personalized support for students.
Target Users:
The primary users of this database will include:
Counselors and mental health professionals: To manage student cases, schedule
appointments, and track progress.
Students: To book appointments and access mental health resources.
Administrative staff: To manage the logistics of the counseling center and generate reports
on utilization.
University management: To monitor and evaluate the mental health services provided to
students.
2. Functionalities:
Here are 25 proposed functionalities for the system:
1. User login with role-based access (student, counselor, admin).
2. Secure password change for all users.
3. Student profile creation and update.
4. Counselor profile management.
5. Appointment booking by students.
6. Real-time counselor availability checking.
7. Session history for students.
8. Secure notes and session details for counselors.
9. Mental health assessments submission by students.
10. Counselor assignment based on student needs.
11. Email and SMS notifications for upcoming appointments.
12. Confidential message exchange between student and counselor.
13. Emergency contact information storage.
14. Crisis intervention alerts for high-risk cases.
15. Anonymous mental health screenings.
16. Generate counseling session reports.
17. Feedback forms for students post-counseling.
18. Analytics dashboard for tracking mental health trends.
19. Export student data for reporting.
20. Counselor scheduling system.
21. Generate usage reports for university management.
22. Session follow-up reminders.
23. Resource library for mental health information.
24. Integration with university's student information system.
25. Counselor performance tracking and feedback.
[Link] Objects:
Create at least 10 database objects/tables, each with relevant attributes. Here’s a sample
breakdown:
NAME ATTRIBUTES
Students Student_ID, Name, Email, Phone,
Emergency_Contact, Mental_Health_Status
Counselors Appointment_ID, Student_ID, Counselor_ID,
Date, Time, Status
Appointments: Appointment_ID, Student_ID, Counselor_ID,
Date, Time, Status
Sessions: Session_ID, Appointment_ID, Session_Notes,
Counselor_Feedback, Duration
Assessments: Assessment_ID, Student_ID, Assessment_Type,
Score, Submission_Date
Feedback: Feedback_ID, Student_ID, Session_ID, Rating,
Comments
Notifications: Notification_ID, User_ID, Type, Message,
Sent_Date
Admin_Users: Admin_ID, Name, Role, Email, Phone
Reports: Report_ID, Report_Type, Generated_Date,
Data_Extracted
Mental_Health_Resources: Resource_ID, Title, Description, Link