Find Jobs
Hire Freelancers

Database assignment

$10-30 USD

Cancelled
Posted almost 8 years ago

$10-30 USD

Paid on delivery
Your buddy stops over for lunch and tells you about his wonderful idea of building software for junk yards. Junk yards are places that aquire cheap old cars and sell individual parts---a $1k old junky car may have 100 parts in it that each can be sold for $20-$50, etc. A typical junk yard may have dozens to hundreds of old cars, and if you need a part, you drive by and ask... the attendant would know what car/part you're looking for and would know whether they have anything compatible in the inventory. (e.g. a "left side mirror from a white 2013 Ford Mustang" may be repainted to be compatible with a red 2014 Ford Mustang). Now, the attendant would likely know these things (they have enormous domain knowledge). But it's still a major inventory hassle to find compatible parts... Your buddy has an idea of building such inventory management system for junk yards... so anyone can start a junk yard, and junk yards can get much bigger. The idea is that the customer would drive in, type in the car/part they're looking for, and the system would tell them if there's a compatible car/part available (and where it is), or can be made compatible with minor tweaks (such as repainting, etc.). If part is not available locally, the software should be internet enabled to find the compatible parts in other junk yards running the same software. License per junk yard, $20k, with $2k/year maintenance, and your buddy thinks he can sell it to at least 10 junk yards near major city centers. So now you have a case for a lucrative business... your task is to build it. Go through the process of designing this inventory system. What are objects? What are events? Create a database schema, etc. How would the search process work? (e.g. go through the motions of: new junky car arrives, how is it inventoried? new customer arrives looking for a part, how does the system find a compatible part? where can humans be eliminated from this process?). Submit writeup of the design (nothing too complicated, just a 1 page description---something that would convince me that you're the right contractor for this project---that you know what you're doing). Also submit database schema (DDL, create table statements), and query statements/process to find a compatible part.
Project ID: 10404904

About the project

10 proposals
Remote project
Active 8 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
10 freelancers are bidding on average $36 USD for this job
User Avatar
Hi there, I went through the requirements and I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.
$30 USD in 1 day
4.9 (25 reviews)
4.3
4.3
User Avatar
I have 5 yrs of experience in SQL development.
$40 USD in 1 day
4.4 (11 reviews)
3.6
3.6
User Avatar
hello brother i will do this job i am doing databse job since 2010 in my software company and i will do it perefctly for you
$50 USD in 2 days
4.9 (2 reviews)
2.7
2.7
User Avatar
I am expert in SQL, DB Modeling, Oracle Certified Professional, Can do the task as per your requirements.
$30 USD in 2 days
1.0 (1 review)
1.5
1.5
User Avatar
Not gonna lie this will be a challenge even for really experienced programmers. And those guys don't charge little. A great idea deserves a great product, the description doesn't mention interface, making everything in the DB can be quite troublesome but more interesting.
$25 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
san diego, United States
5.0
3
Member since May 3, 2016

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.