Help me build a database

[metomeya]

Hi guys,

 

Hoping I can find some help. 

 

I just installed Xampp and I'm trying to use PhpMyAdmin to create a database to do the following:

------------------------------------------------------------------------------

A diet plan that will pull from a database of meals (Breakfast, Lunch, Dinner, Snacks) and create a meal plan for 7 days like this

 

Monday          Tuesday        Wednesday    Thursday, etc.

-Breakfast      -Breakfast

-Lunch          -Lunch

-Snack 1        -Snack 1

-Dinner        -Dinner

-Snack 2        -Snack 2

 

(Snack 1 and 2 will pull from the same database)

 

It will also produce a grocery list for the week

-------------------------------------------------------------------------------

 

So basically the Php/MySql should produce 3 outputs (to MS Word):

1.) A short list of the meals for 7 days

2.) A long list of the meals for 7 days

    (includes ingredients, and cooking directions)

3.) A grocery list

 

-------------------------------------------------------------------------------

 

So I need some help on the database structure does this seem about right??

 

Database: Diet

 

Table 1: Breakfast

Brkfast_Key  Auto_Increment

Brkfast_Name

Ingredient

Ingredient_Amt

Ingredient_Amt_label

Brkfast_Description

 

Table 2: Lunch

Lunch_Key Auto_Increment

Lunch_Name

Ingredient

Ingredient_Amt

Ingredient_Amt_label

Lunch_Description

 

 

Table 3: Dinner

Dinner_Key Auto_Increment

Dinner_Name

Ingredient

Ingredient_Amt

Ingredient_Amt_label

Dinner_Description

 

Table 4: Snack

Snack_Key Auto_Increment

Snack_Name

Ingredient

Ingredient_Amt

Ingredient_Amt_label

Snack_Description

 

Table 5: Ingredients

Ingredient

 

Table 6: WeekMeals

Day_of_Week

Brkfast_Name

Brkfast_Description

Lunch_Name

Lunch_Description

Dinner_Name

Dinner_Description

Snack_Name

Snack_Description

Ingredient

Ingredient_Amt

Ingredient_Amt_label

 

Table 7: GroceryList

Ingredient

Ingredient_Amt

Ingredient_Amt_label

 

 

I'm brand new to MySql, PhpMyAdmin, and Php.  I've only taken a short computer system class in college that cover some information on Microsoft Access so any help would be greatly appreciated.

 

Thanks!

 

(I feel I should say I have posted this same post in other MySQL type forums, I know I shouldn't but just wanted sure I get a response from someone)

[jay7981]

to be honest this forum is more for solving issues with code that you have already written than it is to find a freelance coder,  try googling "PHP/MySQL Freelance" you should find plenty of freelancers that will be more than happy to take this project on.