The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
MAJU Outcome-Based Education (OBE) System
Designed and developed the database for an Outcome-Based Education system at Mohammad Ali Jinnah University (MAJU), with the frontend subsequently implemented in both PHP and C#/.NET.
The system models the relationship between:
PEO → PLO → CLO → Assessment
It provides detailed assessment of courses by CLO and PLO for individual students and supports the management of outcome-based education across university programmes.
Key areas represented
Degrees — BS, MS and PhD
Programmes
Programme Educational Objectives (PEO)
Programme Learning Outcomes (PLO)
Course Learning Outcomes (CLO)
CourseCLOAssessmentStructure
CourseCLOAssessment
Grade Sheets
Transcripts
Major programmes included areas such as Computer Science, Software Engineering, Computer Engineering, Data Science, Artificial Intelligence and Business Administration, along with Biotechnology and Bioinformatics-related programmes. Programme availability varies by degree level.
Database & Technology
Database: MariaDB
SQL: SQL
User Interfaces: PHP and C#/.NET
.NET: .NET Core, C#, Entity Framework Core, ASP.NET Core Identity
Reporting: RDL Reports
Supporting Tool: Excel VBA
The same MariaDB database was used by both the PHP and .NET user interfaces. The PHP version was developed earlier and was practically used with real data; the .NET Core version was developed later.
This project demonstrates database design for a complex academic information system where educational objectives, learning outcomes and student assessment are interconnected through a structured relational database.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Challenges
View all
Related posts
A custom web application for a travel agency.
The client seeks to automate their current manual luggage handling process using an ASP.NET MVC system with integrated printing capabilities.
AI Lead Qualification & Appointment Automation System
AI Lead Conversion Platform — Telegram, CRM & Automated Scheduling
Designed and developed an AI-powered lead conversion system that handles incoming Telegram conversations from first contact to qualification, CRM synchronization, and appointment booking.
The AI works with conversation history, lead profile data, unanswered questions, current funnel stage, available actions, and verified CRM data to determine the next appropriate step and generate structured responses.
The system automatically creates and updates leads in the CRM, manages qualification stages, books meetings, generates Yandex Telemost links, sends reminders, handles rescheduling, and escalates exceptional cases to a human manager.
The architecture includes dialogue state management, message deduplication and batching, PostgreSQL persistence, concurrency protection, validation before actions are executed, and safeguards against sending unverified or prohibited information.
This is not just an AI chatbot — it is an automated sales workflow that connects Telegram, AI, CRM, scheduling, and human escalation into one controlled process.
AI makes decisions within controlled business rules instead of operating as an unrestricted chatbot.
The concurrency safeguards and validation-before-actions detail is a strong distinction here—booking systems usually fail at the edges, not in the happy path. I’d expose a compact lead state to the operator (stage, next action, last unanswered question) so a human can resume...
Excel ERP System | Sales, Purchase & Inventory Management
Built a practical Excel-based ERP system to manage customers, products, vendors, purchases, sales, and inventory.
The system automatically tracks purchased and sold quantities, current stock, stock value, sales, purchases, and profit/loss using Excel formulas and Pivot Tables.
Key skills: Excel, VLOOKUP, SUMIF, Pivot Tables, Inventory Management and Business Reporting.:
