A scalable solution for managing art contest submissions and judging
The Cover Design Contest Platform is a full-stack application built to streamline the submission, management, and judging of art contests. Designed with flexibility in mind, the system handles different contest types (cover designs and bookmarks) across multiple age categories, providing both an intuitive administrative interface and a seamless judging experience.
Managing art contests traditionally involves manual handling of physical submissions and paper-based scoring systems that are:
The client needed a solution to digitize this process while maintaining the integrity of judging and providing accurate management of all submissions.
I began by mapping the existing workflow and identifying key stakeholders:
After analyzing these needs, I developed a database schema that would provide the necessary structure while remaining flexible enough to accommodate different contest types.
I designed a relational database with PostgreSQL (via Supabase) that includes:
The database includes proper security measures with row-level security policies to ensure judges and administrators have appropriate access levels.
I created two distinct interfaces:
Challenge: Handling high-resolution artwork images efficiently while providing zoom functionality.
Solution: Implemented progressive loading with state management for smooth transitions between images. Added zoom controls with keyboard shortcuts for intuitive navigation.
Challenge: Ensuring consistent scoring across multiple judges and preventing bias.
Solution: Designed a standardized scoring system with clear criteria (creativity, execution, impact) on a 0-10 scale. Implemented database constraints to prevent duplicate scoring from the same judge.
Challenge: Maintaining appropriate access levels between administrators and judges.
Solution: Implemented granular row-level security policies in Supabase to ensure judges could only submit their own scores while viewing all entries, and administrators had full control over contest management.
The Cover Design Contest Platform successfully transformed a manual process into an efficient digital workflow:
The Cover Design Contest Platform demonstrates how thoughtful database design and intuitive user interfaces can transform a traditionally manual process into an efficient digital experience. The system successfully balances the needs of administrators and judges while maintaining the integrity of the contest evaluation process.
By leveraging modern technologies like React, Tailwind CSS, and Supabase, the platform provides a scalable solution that can evolve to meet future contest requirements while delivering immediate value through improved efficiency and organization.
Back to Projects Link to Github Repo