Sports Facility Reservation Software Development
Budget: $10 – $30 USD
Project 1: Sports Center Reservation Management System
Context
A sports center offers various facilities (football fields, tennis courts, swimming pools, gyms, etc.) that clients can reserve.
The center aims to modernize its management system by creating a computer application that uses a database to manage reservations, subscriptions, and payments.
Key Features to Implement
1. User Management:
• Register new users (clients) with their personal information (name, surname, email, phone number, address).
Allow users to log in to the application using their account credentials (email and password).
2. Facility Management:
• View a list of available facilities with their descriptions (type, hourly price, available times).
• Search for facilities based on criteria (type, price, availability).
3. Facility Reservation:
• Enable users to reserve a facility based on available time slots.
• Allow modification or cancellation of a reservation.
• Send automated email notifications for reservation confirmations or cancellations.
4. Subscription Management:
• Record monthly or yearly subscriptions for specific activities (e.g., access to the gym or swimming pool).
• Manage subscription expiration dates.
5. Payment and Billing:
• Integrate a module to process payments for reservations and subscriptions (online or on-site)
• Automatically generate invoices for each transaction.
6. Reports and Statistics (Administrator):
• Monitor reservations by day, week, or month.
• Provide statistics on revenue generated by facility type.
• Manage active users and subscriptions.
Technical Constraints
1. Relational Database:
• Main tables: Users, Facilities, Reservations,
Subscriptions, Payments.
• Database: Use SQL under Microsoft Access.
Tasks for Students
1. Analysis and Design:
• Model the system using UML, including use case diagrams, class diagrams, sequence diagrams, activity diagrams, and deployment diagrams.
• Build the Entity-Relationship model and the relational database schema.
2. Implementation:
• Develop the core features of the application.
• Test key functionalities (user registration, facility reservation, payment processing).
Demonstrate the application's functionality.
Context
A sports center offers various facilities (football fields, tennis courts, swimming pools, gyms, etc.) that clients can reserve.
The center aims to modernize its management system by creating a computer application that uses a database to manage reservations, subscriptions, and payments.
Key Features to Implement
1. User Management:
• Register new users (clients) with their personal information (name, surname, email, phone number, address).
Allow users to log in to the application using their account credentials (email and password).
2. Facility Management:
• View a list of available facilities with their descriptions (type, hourly price, available times).
• Search for facilities based on criteria (type, price, availability).
3. Facility Reservation:
• Enable users to reserve a facility based on available time slots.
• Allow modification or cancellation of a reservation.
• Send automated email notifications for reservation confirmations or cancellations.
4. Subscription Management:
• Record monthly or yearly subscriptions for specific activities (e.g., access to the gym or swimming pool).
• Manage subscription expiration dates.
5. Payment and Billing:
• Integrate a module to process payments for reservations and subscriptions (online or on-site)
• Automatically generate invoices for each transaction.
6. Reports and Statistics (Administrator):
• Monitor reservations by day, week, or month.
• Provide statistics on revenue generated by facility type.
• Manage active users and subscriptions.
Technical Constraints
1. Relational Database:
• Main tables: Users, Facilities, Reservations,
Subscriptions, Payments.
• Database: Use SQL under Microsoft Access.
Tasks for Students
1. Analysis and Design:
• Model the system using UML, including use case diagrams, class diagrams, sequence diagrams, activity diagrams, and deployment diagrams.
• Build the Entity-Relationship model and the relational database schema.
2. Implementation:
• Develop the core features of the application.
• Test key functionalities (user registration, facility reservation, payment processing).
Demonstrate the application's functionality.