Programming Projects
RDBMS Programming - Kitchen Planner
This RDBMS project is called Kitchen Planner, and was designed to demonstrate database theory knowledge as well as practical application of database programming concepts. I did this in Access because it was the easiest way to encapsulate code and a DB table structure into a readily observable format for educational purposes.
Kitchen Planner allows someone to organize recipes, plan meals, and automate shopping lists. Based on who’s scheduled to be at a meal (and any dietary needs or culinary eccentricities these people have) appropariate stored recipes are chosen. Once recipes are selected, an automatic shopping list is generated from the required ingredients.
If I were coding this application for an actual commercial product there’d be several obvious features to streamline the workflow. But, this may be useful as it is to someone. I used Access from Microsoft Office Professional to create the database application file… and I made the source file available in the mdb file format.
Languages: Visual Basic
Coding tools: MS Access
Application file: Kitchen Planner.mdb 1.52 MB
Application database schema SQL: Final Project SQL file
Required supporting installs:
Microsoft Access
Final project report: KP-FinalProject.doc


