📅 Scheduling System

A comprehensive scheduling system designed specifically for convenience stores, gas stations, and small businesses to efficiently manage employee shifts and schedules.

🎥 Project Resources

• Video Demo
• Project Slides

🎯 Target Users

• 🏪 Convenience Stores
• ⛽ Gas Stations
• 👥 Business Owners and Employees

💻 Tech Stack

• Backend: Python
• Database: SQL
• Frontend: HTML/CSS
• Design Tools: MySQL Workbench

📁 Project Structure

.
├── Scheduling-system/        # Main system directory
│   └── static/              # Static files (CSS, JS, images)
├── templates/               # HTML templates
├── app.py                  # Main application file
├── schedule.py             # Scheduling logic
├── update.py               # Update functionality
├── test.py                # Testing module
├── new.mwb                # MySQL Workbench database model
├── relationship.mwb       # Database relationships model
└── requirements.txt       # Project dependencies

🚀 Key Features

1. Schedule Management

• 📊 Dynamic shift planning
• 👥 Employee availability tracking
• 🔄 Automatic schedule generation
• ⚡ Real-time updates

2. User Interface

• 💻 Clean and intuitive web interface
• 📱 Responsive design
• 🎨 User-friendly controls
• 📊 Visual schedule display

3. Database Integration

• 💾 Secure data storage
• 🔄 Real-time synchronization
• 📈 Historical data tracking
• 🔍 Quick search functionality

🛠️ Installation

1. Clone the repository

git clone [repository-url]

2. Install required dependencies

pip install -r requirements.txt

3. Set up the database

# Import the .mwb files using MySQL Workbench

4. Run the application

python app.py

📊 Database Schema

The system uses two main database models:

• new.mwb: Primary database structure
• relationship.mwb: Relationship mappings between entities

Key entities include:

• 👥 Employees
• 📅 Schedules
• ⏰ Shifts
• 📋 Availability

💡 System Benefits

For Business Owners

• ⏱️ Time-saving automation
• 📊 Better resource management
• 💰 Cost optimization
• 📈 Improved efficiency

For Employees

• 📱 Easy schedule access
• 🔄 Shift swap requests
• 📋 Availability submission
• 📅 Schedule preferences

🔮 Future Enhancements

1. Mobile Application

   • 📱 Native mobile apps
   • 🔔 Push notifications
   • 📍 Location-based features

2. Advanced Analytics

   • 📊 Performance metrics
   • 💹 Cost analysis
   • 📈 Trend predictions

3. Integration Features

   • 💰 Payroll system integration
   • 📊 HR system connectivity
   • 🔄 API development

📞 Contact

For any questions or suggestions, please reach out:

• 📧 Email: angelachen572@gmail.com
• 🎥 Demo Video: Watch Here
• 📊 Presentation: View Slides