Em Andamento

Creating a SQLite database with table linking

I need someone to create a SQLite database with Python, pupolated with example data. The tricky thing is that I want a table for food, a table for ingredients, and a table for dishes.

So I want to be able to select foods whenever I create a dish, and when I search a dish, I want to be able to query each ingredient of the foods in the current dish. Each food should have any number of ingredients.

So to sum it up, the python script should do the following:

- Create a database with the necessary tables

- Populate the database with example data

- Create a couple of dishes

- Show example code of how to query the ingredients of the foods in a dish

Here's an example of what kind of data I mean:

Table: Foods (ID:XX, food:FoodType)

-ID:01, food:Chocolate Brownie

-ID:02, food:Granola Thins

-ID:03, food:Cheese

etc...

Table: Ingredients (ID:XX, ingredient:IngredientType)

-ID:01, ingredient:Cholesterol

-ID:02, ingredient:Fat

-ID:03, ingredient:Sugar

-ID:04, ingredient:Dietary Fiber

-ID:05, ingredient:Sodium

-ID:06, ingredient:Vitamin C

-ID:07, ingredient:Protein

etc...

Table: Dishes (ID:XX, type:FoodsID, ingredients:[any number of ingredients], amount=AmountForEachIngredient)

-ID:01, type:Chocolate Brownie, ingredients:[Cholesterol, Sodium, Protein], amount:[40g, 10mg, 10%]

-ID:02, type:Granola Thins, ingredients:[Sodium, Vitamin C], amount:[20g, 75mg]

etc...

Python 2.7 on Windows

Habilidades: Python, Microsoft SQL Server

Ver mais: Sqlite, dietary, python search database, create database food, sqlite python, python sqlite database, sqlite example, food database, select sqlite, cholesterol, linking data, example sqlite, creating database sqlite php4, populate database script, script populate database, linking script, dish code, sqlite script, extract name table database vb6, free webpage table database, linking access database vbnet login, 2008 linking access database, linking access database net program, linking access database, database sqlite excel

Acerca do Empregador:
( 13 comentários ) NA, Norway

ID do Projeto: #6804493

Premiar a:

suraj99p

I am highly experienced in database interaction in python. I have done many projects which required to interact with mysql and sqlite in python. I have 5 years of experience and can give a very good solution. I have Mais

$50 USD em 1 dia
(20 Avaliações)
5.2

7 freelancers estão ofertando em média $43 para este trabalho

anuyadav1

i can create this python script with sample sqlite database .

$50 USD em 1 dia
(34 Comentários)
5.2
rinsadsl

Hi Good Day I am quite good with python 2.7, SQLLite and database programming. I can handle this project without an issue. Looking forward to hear from you. Thanks Rinsad

$54 USD em 1 dia
(3 Comentários)
3.6
ToGoBananas

I understood the job. will finish work quickly, will make qualitatively. Have experience with sqlite and python.

$25 USD in 2 dias
(0 Comentários)
0.0
tanmay1986

Although I am new to freelancing, but I believe I have the necessary skills for the project. Please feel free to contact me if any queries. Thanks and Regards

$35 USD em 1 dia
(0 Comentários)
0.0
davidadamczykcz

I have 3 years experience with Python development, software design and data modeling. I recommend as first step create database, populate the database with example data and programming Python script.

$50 USD em 1 dia
(0 Comentários)
0.0
hogiabao2601

Đề xuất vẫn chưa được gửi

$40 USD in 3 dias
(0 Comentários)
0.0