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)