Project Description

This application addresses the domain of food truck fleet operations and logistics management. It is designed to manage the daily activities of companies operating multiple food trucks at diverse locations and events. Effective coordination of trucks, staff, schedules, menus, inventory, and event bookings is essential for efficient food truck business operations. The application facilitates the organization of these operational components by storing and managing structured data related to the food truck fleet.

The database models several important operational aspects of food truck fleet management:

1. Food Truck Management: Stores operational details of each truck, such as cuisine type, capacity, and identification information.
2. Staff Management and Role Specialization: Tracks employees and their specialized roles, including chefs, drivers, and cashiers.
3. Scheduling and Location Assignment: Records when and where each food truck operates.
4. Menu Management: Maintains information about food and beverage items offered by trucks.
5. Event Participation: Tracks food truck bookings and participation in special events.
6. Inventory and Supply Tracking: Monitors ingredients and supplies used by food trucks.
7. Staff Shift Assignment: Records which staff members work specific truck shifts.

This application domain is suitable for a CPSC 304 project because it models a realistic operational system that requires structured data organization. Food truck fleet management involves multiple entities, relationships, specialization hierarchies, scheduling, and resource allocation.

Database Specification

The database is capable of supporting the operational management of a food truck fleet by storing, organizing, and retrieving information related to food trucks, staff, schedules, locations, menus, events, and inventory. The database system allows users to assign food trucks to operating locations and dates, manage staff assignments, and track which staff operate assigned food trucks during scheduled times.

The database system also enables users to manage menu items, track food truck participation in events, and monitor inventory items used during operations. Furthermore, the database system allows users to track operational schedules and manage the allocation of resources such as staff, food trucks, and inventory. In general, the database system offers organized data management to facilitate the efficient planning and coordination of food truck fleet operations.

Er Diagram