Please enable JavaScript.
Coggle requires JavaScript to display documents.
Community centres - Coggle Diagram
Community centres
- Centralised digital platform for Queensland community centres
- Improve accessibility and digital engagement
- Replace fragmented booking systems
- Enable real-time activity visibility
- Securely manage user data
-
-
-
-
-
-
- Role-based access control
-
-
- Community Centre Managers
-
-
-
- Accessible interface (WCAG 2.1 AA)
-
- Efficient activity approval
- Simple registration process
- Accessibility: Alt text, Labelled inputs, Error messages, High contrast colours
- Effectiveness: Auto-show today's activities, Clear navigation
- Safety: Password enforcement, Role-based permissions
- Utility: Multi-centre support, Activity management
- Learnability: Consistent layout, Uniform buttons, Simple navigation bar
-
- Must use relational database
-
-
-
-
- Database: community_centres_db
- Users: id (PK), name, email, password (hashed), role, preferences
- Centres: id (PK), name, suburb, postcode
- Activities: id (PK), centre_id (FK), title, description, date, time, cost, max_participants, status
- Registrations: id (PK), user_id (FK), activity_id (FK)
- Admin_logs: id, admin_id, action, timestamp
- One centre → many activities
- One activity → many registrations
- One user → many registrations
- Database Structure: 3NF, Primary keys, Foreign keys, No redundant data
-
-
- Verify using password_verify()
-
- Redirect to activities page
-
- Query approved activities
-
-
-
-
-
- Insert into registrations
-
-
-
-
-
- At least 1 special character
- Client Side: HTML, CSS, Bootstrap, JavaScript
-
- Environment: XAMPP, phpMyAdmin, Localhost testing
-
- Strong password validation
-
-
- Role-based access (admin/user)
- Display today’s activities automatically
-
-
- Admin approval of activities
-
-
- Capacity control per activity
-
- Responsive design (Bootstrap)
- Secure password hashing (bcrypt)
-
- Fast load time (<3 seconds)
-
-
- Cross-browser compatibility