Find Jobs
Hire Freelancers

Creating a SQLite database with table linking

$10-50 USD

Completed
Posted over 9 years ago

$10-50 USD

Paid on delivery
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...
Project ID: 6804493

About the project

7 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 also done vast amount of database modelling.
$50 USD in 1 day
4.8 (20 reviews)
5.2
5.2
7 freelancers are bidding on average $43 USD for this job
User Avatar
i can create this python script with sample sqlite database .
$50 USD in 1 day
4.9 (34 reviews)
5.2
5.2
User Avatar
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 in 1 day
4.7 (3 reviews)
3.6
3.6
User Avatar
I understood the job. will finish work quickly, will make qualitatively. Have experience with sqlite and python.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Đề xuất vẫn chưa được gửi
$40 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NORWAY
NA, Norway
5.0
13
Payment method verified
Member since Dec 15, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.