メディ

MEDY VILLARIAS000
Back to portfolio

Agriculture Information System (AIS)

Code on GitHub

A centralized agricultural operations and crop tracking system with a 3NF relational database.

I designed and built a web-based Agriculture Information System for managing farmers, farm plots, crop catalogs, planting cycles, and harvest outputs. Built with native PHP PDO and Supabase PostgreSQL with a fully normalized 3NF schema (13 domain tables + append-only audit trail), database-driven dropdowns, system-wide soft deletes, and responsive Tailwind UI.

  • Full 3NF normalization with 13 domain tables and audit logging
  • Centralized farmer, farm, planting, and harvest lifecycle tracking
  • Dynamic revenue calculations and system-wide soft deletes
PHP (PDO)PostgreSQLSupabaseTailwind CSSHeroicons
Agriculture Information System (AIS)

Screenshots