Skip to content
Mohamed Aslam
BUILTArchived

Online Shopping System

A coursework database system built on stored procedures rather than application-side queries.

Snapshot

My role
Developer
Timeframe
Singapore Polytechnic coursework
Status
Archived
Organisation
Singapore Polytechnic

The problem

A PostgreSQL-backed shopping system where the CRUD paths run through stored procedures, built for a Singapore Polytechnic module.

How the project ran

I owned

  • Designed the schema and wrote the stored procedures behind each operation.

Constraints

  • Module required the logic to sit in the database layer.

Outcome

  • Completed and submitted as coursework.
What I owned, what constrained it, and where it got to.

Built with

  • PostgreSQL
  • SQL
  • Stored procedures

Related work

LocalLoco consumer app: "Discover Local Deals, Singapore" with a search bar, currently showing an empty "No deals available yet" state
BUILTPrototype

LocalLoco

Neighbourhood deal discovery, sourced by residents rather than a sales team.

Role
Full-stack developer and co-founder
Timeframe
September 2024 – present
Recenter landing screen offering three modes: Breathe, Reflect, and Create
BUILTLive

Recenter

A wellness app for a two-minute reset: guided breathing, reflection, or creative flow.

Role
Frontend developer
Timeframe
Personal project