Fixer Uppers Website - Database Design

A web platform connecting homeowners with trusted service professionals, featuring job postings, contractor profiles, and a rating system.

E-R Design illustrating table relationships for Fixer-Uppers.
Complete Relational Database Design for Fixer-Uppers site, with relationships represented by arrows indicating foreign keys.
State transition diagram for Fixer-Uppers mock up site.
Fixer-Uppers Home page implementation (left) compared with Figma design (right).
Figma Design
Fixer-Uppers Sign Up page implementation (left) compared with Figma design (right).
Figma Design
Fixer-Uppers Jobs page implementation (top) compared with Figma design (bottom).

MPPT Energy System Mobile App Details

For my Database Design graduate course's final project, I led the database design and system architecture for Fixer-Uppers, a mock up site that connects homeowners with reliable local service professionals. I developed the Entity-Relationship (E-R) model and relational database structure, ensuring logical relationships, accurate data storage, and future scalability. After submitting the initial E-R design to my professor, he singled out my team’s work as exemplary and asked me to present it to the class as a model for how the database design should be done; a presentation I delivered alone as team captain. Users can post job requests, and contractors can browse, accept, and update jobs. A review system enables both parties to provide feedback, fostering trust and accountability across the platform.

I also contributed to the system architecture and front-end implementation, including the state transition diagram and page descriptions for key components such as Home, Job Postings, My Jobs, and User Profiles. Using Figma, I helped designed a cohesive interface with a vibrant color palette to enhance usability and accessibility. On the technical side, I implemented core pages using Next.js, JavaScript, and CSS, integrating them with AWS for backend functionality and deployment. Manual exploratory and ad hoc testing ensured that the platform was intuitive, reliable, and user-friendly.

Building the Fixer-Uppers website showed us how important a solid database design is when creating a reliable and user-friendly system for solving real-world problems.

The Fixer-Uppers project demonstrated how thoughtful database design, clear system architecture, and careful UI planning can create a practical, scalable web application. By integrating functionality, usability, and trust-building features, the platform provides homeowners with a reliable way to find professionals while giving contractors access to consistent work opportunities.

Project information

  • Category Full-Stack
  • Technologies Next.js, AWS, JavaScript, CSS, Figma, Git/GitHub
  • Skills Project management, Database design (E-R modeling, relational database creation), System architecture design (state transition diagrams, page descriptions), Web development, UX/UI design, Manual testing and quality assurance
  • Project dateFebruary 2025 - May 2025
  • Wireframes Download Hand-Drawn Low-Fidelity Wireframes by Lesli Perez
  • Final Report Final Report Download
  • Project URL GitHub Link