Database assignment

Cancelled Posted 7 years ago Paid on delivery
Cancelled 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.

Database Programming PostgreSQL

Project ID: #10404904

About the project

10 proposals Remote project Active 7 years ago

10 freelancers are bidding on average $36 for this job

it2051229

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
(25 Reviews)
4.3
ashupathania

I have 5 yrs of experience in SQL development.

$40 USD in 1 day
(11 Reviews)
3.6
Mazharhameed91

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
(2 Reviews)
2.7
ZishanChuhan

I am expert in SQL, DB Modeling, Oracle Certified Professional, Can do the task as per your requirements.

$30 USD in 2 days
(1 Review)
1.5
lucasibsteffen

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 i More

$25 USD in 10 days
(0 Reviews)
0.0