The task

Based on the organic food already in the product portfolio, a recipe service with a recipe box adapted to it is to be introduced. In addition, there should be an option to filter recipes based on specific nutritional categories and restrictions based on allergens / intolerances.

The boxes should then later be filled according to the ingredients and quantities used in the recipes.



Expand the existing database to support the features you want.

Note: The development and connection of a graphical user interface is not a mandatory part of this task, but can be done optionally if you have the appropriate prior knowledge.



Customer requirements to be implemented:



Storage of recipes consisting of several ingredients

Storage of nutrition categories

Storage of restrictions/allergens

Composition of ingredients according to a recipe

Selection of recipes according to given nutritional categories

Selection or exclusion of recipes based on restrictions

optional: access control of personal data

The Kraut und Rüben also asks you to develop a concept for the cases



that a customer requests information about his data according to DSGVO or

requested the deletion of his data.

Clarify the legal basis for both cases and implement the technical implementation (e.g. As an SQL script).



Requirements for the queries to be developed by you:



Implement the following requirements using SQL queries:

Selection of all ingredients of a recipe by recipe name

Selection of all recipes of a specific nutrition category

Selection of all recipes that contain a certain ingredient

Calculation of the average nutritional values of all orders from a customer

Selection of all ingredients that have not yet been assigned to a recipe

optional for Fisi and itse or mandatory for fiae and fidp:

selection of all recipes that do not exceed a certain amount of calories

selection of all recipes that contain less than five ingredients

select all recipes that contain fewer than five ingredients and meet a specific nutritional category

create at least three more queries

make sure you create at least one query each with inner join, left join/right join, subselects, and aggregate functions in total







upd: you are free to use whichever db you want. You can also add your ideas.

Category: IT & Programming
Subcategory: Other
Project size: Small
Is this a project or a position?: Project
I currently have: Not applicable
Required availability: As needed
API Integrations: Other (Other APIs)

I need to develop a brand new app where the user can search for fitness centers close to their location or on a preferred one. It should include a built?in NFC system. I am ready to start immediately.

Category: IT & Programming
Subcategory: Apps programming. Android, iOS and others
What is the scope of the project?: Create a new app
Is this a project or a position?: Project
I currently have: I have an idea
Required availability: As needed
Required platforms: Android, iPhone
I need to: Create an app
App type: Other
Similar apps: Airbnb

I need a Moodle expert to assist me in completing the Paypal config for a course already set up in Moodle and answer other Moodle questions. Using MoodleCloud. Course already set up. Need to connect it to Paypal from Moodle and our website.

Category: IT & Programming
Subcategory: Other
Project size: Small
Is this a project or a position?: Project
I currently have: Not applicable
Required availability: As needed
API Integrations: Payment Processor (Paypal, Stripe, etc.)

Hello, we are a small Free Tours company.
We want to create a dynamic website to attract more customers. We only ask for a simple design and a booking calendar. These are some of the elements that have to be on the page and that we consider basic:
- Booking system synchronised with Google Calendar.
- That the client receives an email with the booking information and the meeting point of the tour.
- To be able to show the tours offered in an attractive way.
- To be able to manage our booking system to be able to modify schedules, group sizes and make cancellations.
- To be able to offer the tours in different languages and to be able to change the page to English, French and Spanish.
- That the website should have a very good SEO positioning to be able to appear at the top of the search pages in searches for our city.

We have a large part of the design finished. It is highly recommended to be able to continue with the project in Hostinger and Wordpress, as we already have the licenses.

Category: IT & Programming
Subcategory: Web design
What is the scope of the project?: Medium-sized change
Is this a project or a position?: Project
I currently have: I have the design
Required availability: As needed
API Integrations: Social media (Facebook, Twitter, etc.)
Specific need: Create a WordPress site

I need two kind of apps to work with home assistant the first one is a sip client and the another one is an alarm system able to send some contactid messages through the sip client.

Category: IT & Programming
Subcategory: Other
Project size: Small
Is this a project or a position?: Project
I currently have: I have an idea
Required availability: As needed

I have developed a tool using Excel for Economic Feasibility Analisys in Energy Projects (Cash flow, irr, npv, payback, sensibility analisys ...)
Now, I want to develop a similar tool but using PowerBI + DAX to make it available online for my customers, where they can change some inputs manually and get the updated feasibility indicators.

Category: IT & Programming
Subcategory: Apps programming. Android, iOS and others
What is the scope of the project?: Create a new app
Is this a project or a position?: Project
I currently have: I have the design
Required availability: As needed
Required platforms: Other
I need to: Create an app
App type: Utility - Utility application (flash, calculator, etc.)
Back-end is required: Yes
Payment gateway: Yes

Melody's is a Restaurant where you can come and hear some music while you eat some tasty food, we need a page for the restaurant

Category: IT & Programming
Subcategory: Web development
What is the scope of the project?: Create a new custom site
Is this a project or a position?: Project
I currently have: I have an idea
Required availability: As needed
API Integrations: Social media (Facebook, Twitter, etc.)
Roles needed: Design a landing page, Developer, Designer