The Cultural Committee Database System is an academic project developed as part of the Database Management System (DBMS) course. The project focuses on analyzing a real-world organizational problem and designing an efficient database solution for managing cultural committee activities at DAU.
The primary goal of this project is to understand the complete database development lifecycle, including requirement gathering, SRS preparation, conceptual database design, logical database design, and implementation. A basic website interface is developed only to demonstrate the functionality and working of the designed database.
The system provides a structured method to manage event details, student participation, committee members, and registrations while ensuring data consistency and reduced redundancy.
DAU’s Cultural Committee needs a database to manage events, and student members. It should store details of committee members, club activities, event schedules, and budgets. The system should also track participant registrations, performances, and feedback from students and faculty.
🏗️ System Scope
The Cultural Committee Database serves as a comprehensive hub that supports the complete event lifecycle, including:
- Event proposal submission and approval
- Participant registration management
- Budget planning and financial tracking
- Vendor and sponsorship coordination
- Feedback and performance analysis
- Event scheduling and resource allocation
The system is designed to improve collaboration between students, faculty, committee members, and administrative staff while reducing administrative workload.
- Software Requirement Specification (SRS)
- Requirement Analysis
- Entity Relationship Modeling
- Relational Schema Design
- Database Normalization
- Primary and Foreign Key Constraints
- Stored Procedures and Functions
- Role-Based Access Control
- Data Integrity and Consistency Enforcement
- PostgreSQL
- PL/pgSQL
- pgAdmin
- HTML
- CSS
- JavaScript
- JAVA
This project is developed strictly for educational and academic learning purposes under the DBMS curriculum at DAU.
This project was developed as a collaborative academic assignment under the Database Management System course.
- Team Members
- Shaikh Maryam Mohammed Farooq
- Anistina Augustin Dsouza