Skip to content

README.md

Latest commit

 

History

History
71 lines (49 loc) · 2.59 KB

README.md

File metadata and controls

71 lines (49 loc) · 2.59 KB

Cultural-Committe-Database-Project

📌 Project Overview

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.

🧩 Problem Statement

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.

🗄️ DBMS Concepts Implemented

  • 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

💻 Technologies Used

Database

  • PostgreSQL
  • PL/pgSQL

Database Management Tool

  • pgAdmin

Interface Demonstration Layer

  • HTML
  • CSS
  • JavaScript
  • JAVA

📜 Academic Purpose

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
    1. Shaikh Maryam Mohammed Farooq
    2. Anistina Augustin Dsouza