10. Database Design (ER Diagram)
The database is designed around six core entities: Customer, Booking, Game/Equipment, Payment, Admin/User, and Report. Each booking links a customer to a piece of equipment for a specific time slot, and automatically generates a payment record once the session ends. Administrators can view consolidated reports drawn from booking and payment data.
Simplified Entity Relationship (ER) Diagram
Six entities connected by the labelled relationships shown below.
Accessible view
The ER diagram contains six entities and these labelled relationships:
- Customer makes Booking.
- Booking reserves Game/Equipment.
- Customer registers with Admin/User.
- Booking generates Payment.
- Payment feeds Report.
- Admin/User views Report.
11. Work Plan
| Phase | Activity |
|---|---|
| Phase 1 | Requirement Analysis |
| Phase 2 | Literature Review |
| Phase 3 | System Design |
| Phase 4 | Database Design |
| Phase 5 | Coding and Development |
| Phase 6 | Testing |
| Phase 7 | Documentation |
| Phase 8 | Final Submission |