CASE STUDY
Community Land Use & Zoning Database
Designing a relational database to support land administration, zoning compliance, and urban development management.
ROLE
Database Designer & Data Analyst
PLATFORM
MySQL
FOCUS
Data Analytics · Business Intelligence · Urban Planning
LIVE
The Real Problem
Urban planning and land management rely on large volumes of interconnected information, including parcels, ownership records, zoning regulations, development applications, and permits. Without a well-structured database, tracking land use changes, monitoring compliance, and supporting planning decisions becomes inefficient and error-prone.
The Approach
Design a normalized relational database that centralizes land administration data while maintaining data integrity, supporting efficient queries, and enabling long-term monitoring of land use and development activities.
The project focused on modeling relationships between planning entities, enforcing referential integrity, and creating a scalable schema capable of supporting planning workflows and policy analysis.
What I Built
- Designed a normalized relational database using MySQL and Entity Relationship Modeling (ERD)
- Developed interconnected tables for parcels, ownership, zoning, land use, permits, and development applications
- Established primary keys, foreign keys, and relational constraints to maintain data integrity
- Structured the database to support zoning compliance, development control, and land use monitoring
- Created SQL queries to retrieve planning insights, identify zoning conflicts, and monitor development activities
What Changed
- Centralized land administration data into a structured relational database
- Improved consistency and traceability of land use, zoning, and development records
- Enabled efficient reporting for planning, policy monitoring, and development control
- Demonstrated how relational databases can support evidence-based urban planning and land management