Together Culture - CRM Software

📌 Project Overview

This project is a Customer Relationship Management (CRM) software developed for Together Culture, a Community Interest Company focused on fostering an equitable and ecological creative economy. The goal of this project is to transition the company from a manual data management system to a digital CRM solution that streamlines member engagement, event management, and activity tracking.

🛠️ Features Implemented

• 🔐 User Authentication - Members can log in to a password-protected portal.
• 📊 Dashboard & Insights - Members can track their benefits, past event participation, and get event recommendations.
• 📅 Event Management - Members can browse, book, and track events.
• 🔍 Advanced Search & Filtering - Admins can search members, events, and participation history.
• 🎭 Membership Tiers - Support for Community Members, Key Access Members, and Creative Workspace Members.
• 📌 Digital Content Modules - Members can enroll in digital learning modules and track their engagement.
• 📄 Admin Controls - Admins can add new members, track interests, and monitor engagement trends.

💻 Technologies Used

• Programming Language: C# (.NET Framework)
• Database: MySQL
• Development Tools: Microsoft Visual Studio, GitHub
• Design Tools: Lucidchart, Visual Paradigm, MermaidChart
• Version Control: Git & GitHub

🗂️ System Architecture & Design

1️⃣ Wireframes

2️⃣ Entity-Relationship Diagram (ERD)

3️⃣ UML Diagrams

• Use Case Diagram - Defines system functionalities for Members and Admins.
• Class Diagram - Shows system entities, attributes, and relationships.
• Sequence Diagram - Illustrates user interactions with the system.

🚀 Installation Guide

1️⃣ Clone the Repository:

[https://github.com/QuantumAlchemist03/CommunityEngageDB-Design.git]

2️⃣ Set Up the Database:

• Import the MySQL database schema (database.sql).
• Configure the database connection string in the appsettings.json file.

3️⃣ Run the Application:

• Open the project in Visual Studio.
• Click Start (▶️) to launch the application.

🛠️ Testing & Debugging

• Unit Testing: Conducted automated tests to ensure system reliability.
• Functional Testing: Verified user authentication, event booking, and admin features.
• Performance Testing: Optimized database queries and page load times.

🛠️ Maintenance & Future Enhancements

✅ Bug Fixes & Patches - Regular updates to fix issues and optimize performance. ✅ Feature Upgrades - Potential enhancements include event recommendations using AI and a chatbot for member interactions. ✅ Security Audits - Periodic security checks to protect user data.

👨‍💻 Contributors

• Alif Sathar - Event Page, Digital Content Module, UI/UX Design, Software Testing
• Jakes Jacob Mathew - Backend Development, Database Optimization
• Muhammed Aseem - Admin Dashboard, Authentication System
• Niroshan Kekulawala - Member Management, User Role Implementation

📧 Contact

For questions or contributions, reach out via:

• 📩 Email: alifsatharofficial2003@gmail.com

---

🚀 If you find this project helpful, don't forget to ⭐ star the repository!

License

This project is not open-source and is protected under a custom all-rights-reserved license.
Unauthorized use, copying, or distribution is strictly prohibited. See LICENSE.txt for details.