← Back to Projects
Zoo Database Management System
Full-stack zoo management system with advanced MySQL features
ReactNode.jsMySQLAWSFull-Stack
What it does
A comprehensive full-stack Zoo Management System designed for managing animals, employees, exhibits, ticketing, and retail operations. Built with AWS-hosted MySQL database and features role-based access control for different user types.
How it works
- •Dynamic web application with CRUD operations for all entities
- •RESTful APIs built with Node.js and Express manage real-time data
- •Role-based access control ensures proper permissions for different user types
- •MySQL database with advanced features: triggers, stored procedures, and soft deletes
- •React frontend provides intuitive interface for staff and administrators
- •AWS-hosted database ensures scalability and reliability
Tech stack
ReactNode.jsExpressMySQLAWSRESTful APIsJavaScript
My contribution & impact
- ✓Led team of 5 developers through full SDLC
- ✓Architected relational database schema with advanced MySQL features
- ✓Implemented comprehensive CRUD operations across multiple entities
- ✓Built dynamic React frontend integrated with RESTful APIs
- ✓Deployed MySQL database on AWS for production environment
- ✓Designed role-based access control system for security
What I'd improve next
- →Add reporting and analytics dashboard for zoo management
- →Implement mobile app for field staff and visitors
- →Add real-time inventory tracking for retail operations
- →Integrate payment processing for ticket sales