Auntie Enterprises Inc. requires a robust database system to efficiently track ingredients purchased from various suppliers. The system should record purchase dates, quantities by weight, and the specific recipes in which these ingredients are used. Additionally, it should track where the finished items are sold. The project aims to integrate this data with popular e-commerce platforms like Square and Shopify, ensuring seamless data flow and accessibility. The database will be cloud-based, providing scalability and remote access. This project will enable Auntie Enterprises Inc. to streamline their inventory management and sales tracking processes, ultimately improving operational efficiency.

Key points:

- Track ingredients from various suppliers.

- Record purchase dates, quantities, and usage in recipes.

- Track sales of finished items.

- Integrate with Square and Shopify.

- Cloud-based storage for scalability and remote access.

The project deliverables include a fully functional cloud-based database system that tracks ingredient purchases, usage in recipes, and sales of finished products. The system will also feature integration with Square and Shopify for seamless data synchronization. Additionally, comprehensive documentation and a user manual will be provided to ensure ease of use and maintenance.

Key deliverables:

- Cloud-based database system.

- Integration with Square and Shopify.

- Comprehensive documentation.

- User manual for ease of use and maintenance.

Students will be given access to management for guidance and the company website. Before starting, the student should create a plan that outlines which steps they think should be taken to complete the project and how they will ensure the data is secure.