I need a secure, well-structured database system dedicated to our school’s fee records. The core focus is capturing and managing payment transactions in real time, then making that information available to students and parents through a simple login interface. Key points • Database scope: fee payment transactions only (no grade or staff data for now). • Primary users: students and parents; an admin panel will still be required for me and my team to add, edit, or correct entries. • Access: web-based dashboard is preferred, yet I’m open to a lightweight API that could later feed a mobile app if you think that future-proofs the build. • Security: role-based permissions, encrypted credentials, and activity logs are must-haves. Deliverables 1. Normalised database schema (MySQL, PostgreSQL, or another mainstream SQL engine). 2. Admin interface to upload, update, and export payment data. 3. Read-only portal for students/parents to view their own transaction history and outstanding balances. 4. Documentation: setup steps, ER diagram, and brief user guide. I’m happy to review tech stack suggestions, but please outline how you will safeguard data and keep the system scalable for a growing student body.