dkhwang118 / CIS560_F18-Project-RecipeManager

KSU - Fall 2018 - CIS560 - Database Project - ProjectTeam1

GNU General Public License v3.0

1 stars 2 forks source link

New Queries #37

Open dbramucci opened 5 years ago

dbramucci commented 5 years ago

Report Queries

Average Number of Ingredients
# of recipes per categories

Question Queries

Get by ID Queries
Get available recipes
Shopping List Query

dbramucci commented 5 years ago

Some useful data

Unit Price for ingredients
- Adds average price
- Rank categories by price of recipes
Keep track of recipe usage
- Date (how long sense last made)
- Could update a raw count table with a trigger

dbramucci commented 5 years ago

New Question Queries

Want to eat a recipe priced between $x and $y, purchased now
Have $a dollars available to buy extra ingredients plus the pantry

dbramucci commented 5 years ago

Add a Nullable column for user rating to get idea of "quality of each category"

dbramucci commented 5 years ago

Nutrition Labels (for Ingredients/Recipes)

dkhwang118 commented 5 years ago

So, with a minority consensus, it seems that the 4 REPORT-type queries will be:

Get All Recipes that can be made w/ current pantryItems and given dollar amount
Get Top user-rated recipes in each category (possibly with user-given int value for top)
Get all recipes Not Cooked Recently
Get Average Recipe Rating per Category

If this is a change from what we originally talked about, please message, but as the GUI needs to be made for the Stats, I believe defining the REPORT queries will give the GUI-maker(s) specifics to work with.

I will begin work on 1, and work my way down, but if anyone else wishes to work on the queries, please feel free.

dkhwang118 commented 5 years ago

The 4 methods to support the REPORT-type queries in my above comment have now been merged into master.