Wesal is a computerized Help Desk management system developed to improve customer support and streamline issue resolution. This project covers the full lifecycle of database design, from conceptual modeling to cloud-based implementation.
The project followed a professional database design workflow using industry-standard tools:
- Conceptual Design (EER): Developed using draw.io to create an Enhanced Entity-Relationship model.
- Logical Design (Relational Schema): Transformed the EER model into a Relational Schema using Miro.
- Implementation: Developed the physical database using the Supabase SQL Editor (PostgreSQL).
- Ticket: Manages support requests with attributes such as priority, status, and creation/resolution dates.
- Customer: Represents individuals or organizations submitting requests.
- Support Agent: Staff responsible for resolving tickets, categorized by roles and skills.
- Department: Different units like IT, HR, and Finance that handle specific issues.
- Cloud Implementation: Managed via Supabase for modern SQL execution.
- Database Integrity: Defined Primary Keys, Foreign Keys, and Constraints (NOT NULL, UNIQUE).
- Data Population: Populated tables with at least 6 realistic records per entity.
- Complex Queries: Implementation of SQL queries and views to extract system insights.
- Modeling: draw.io & Miro.
- Database: Supabase (PostgreSQL).
- Language: SQL (DDL, DML, DQL).
- Course: Principle of Database Project (CS1370).
- University: Imam Mohammad Ibn Saud Islamic University.