Healthy Nutrition Project - Dream Team

Description:

A food delivery company is implementing an app that will offer a daily meal plan based on body mass index.The plan is selected for 1/3/6 months (more is cheaper). Each plan has several menu options (~3). Each menu option contains information about calories, protein/fat/carbohydrate content.

The server part has the information:

about the plans: (example) low-calorie, moderate, high-calorie
about the contents of the menu: the list of dishes, calories, etc.
about the clints (further in the tables)
about the execution of orders

The client has the information:

personal data
data on your order

Tables:

meal plan	menu	customers	orders
id \| type \| period \| price \| menu number	id \| breakfast\| lunch\| dinner	login \| password \| weight\|height\| gender \| meal plan id	customer id \| login \| date \| plan id \| period \| price

menu and meal plan are linked by id

We pull up the period and price from the plan by the plan id

The function of client login by login and password (you can also register, if you are not lazy)

Using select to issue the following information:

For all orders: the amount of money received for the specified period according to the menu that is in the greatest demand
For all orders: information about the number of plans sold and the amount of money received (grouping by plans)

Provide data updates using insert, delete, update

Create a function to increase (decrease) the price for a certain %

Create a function that displays information about all accepted orders on a certain date

Create a function that allows you to change the meal plan and then recalculate the cost

Installation:

Execute Commands:

		git clone git@github.com:fpmi-tp2023/labrabota5pr1-dreamteam.git
		git pull

Or download ZIP file

Usage:

Execute Commands:

		make
		bin/program

Contributing:

The authors of the project:

Maxim Emelyanovich - coder
Danila Tsatsuk - content maker
Yanchuk Bronislav - team leader / tester
Viktor Drobyshevsky - SQL Manager