Find Jobs
Hire Freelancers

Create a simple database - sqlite

$10-30 CAD

Cancelled
Posted about 10 years ago

$10-30 CAD

Paid on delivery
Please make a database for a sample menu. The instructions are below. Please make it as if it were a real database with the start time and end time or duration etc. Database Menus - Every menu (Category) must have at least one sub Category startDate is the time of the day in seconds that the category/sub category is available Duration is how long in seconds it is available from that time Items - About 6-12 items per menu - Items are only added to the sub Categories - At least one or two menus with 24+ items (These can be split across multiple sub categories) - All of the relevant information for the items needs to be filled in (Name, descriptions, price, startdate/duration, refilprice, subid) StartDate - If the item is only to be offered after a certian time (Input the time in seconds from the start of the day) (-1 if always available) Duration - Amount of seconds the item is to be available (-1 if always available) refilprice - (-1) if not refillable subId - Id of the Sub Category that the item belongs to Items will need 3 images Small images - Needs to be called sml_(id in table) Ex (If the id of the item is 5 then the name will be “sml_5” Large Images - Needs to be called lrg_(id in table) Ex (If the id of the item is 5 then the name will be “lrg_5” Nutrition Images - Needs to be called nut_(id in table) Ex (If the id of the item is 5 then the name will be “nut_5” The small images should be around 16/9 to 8/5 (in our case since we will be showing it on my phone use around 640x200 for best results (it might be cropped slightly) The large Images should be around 1280x635 for best results (it might be cropped slightly) Customizations We will also need customizations for the items. These need Name, reduction price, addition price; Reduction and addition prices are only needed if they change the cost of the item when added/removed, otherwise set to 0 The ItemCustomization table is used to link a customization to an item since multiple items can use the same customization Promotions Promotions need start and end date in milliseconds There are multiple websites that can convert such as: [login to view URL] PriceAdjust - This is a percentage Ex: 100 is a 100% price reduction 25 is a 25% price reduction itemPromotions table is used to link promotions with items
Project ID: 5723624

About the project

4 proposals
Remote project
Active 10 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
4 freelancers are bidding on average $206 CAD for this job
User Avatar
Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$618 CAD in 2 days
5.0 (511 reviews)
7.5
7.5
User Avatar
Greetings i am ready to develop database in sqlite as per your requirments Thanks
$33 CAD in 1 day
4.8 (28 reviews)
4.8
4.8
User Avatar
Hi - I am a recent graduate with a degree in Computer Science. I have looked at all the websites, and I would love to help you with this project. I have experience using sqLite, PostGres and MySQL databases. Can you clarify - you'd like more than the schema, you'd like an actual database exported filled with made-up information? Additionally, do the images need to be placed in a specific folder, or just named like (sml_5) [although, I am not sure why you would need a database then if you know the naming convention]. Thanks, Tally
$24 CAD in 2 days
5.0 (4 reviews)
3.4
3.4
User Avatar
I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$20 CAD in 1 day
5.0 (3 reviews)
0.8
0.8

About the client

Flag of CANADA
Toronto, Canada
5.0
3
Member since Apr 11, 2013

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.