Find Jobs
Hire Freelancers

Design Database

$30-250 AUD

Cancelled
Posted almost 7 years ago

$30-250 AUD

Paid on delivery
Need an database designed in mysql - Pure Tables - No procedures or views. Specfications is very simple. 1. A PRoduct(System) has multiple components (parts) - eg -< Car (systems) - products wheels brakes, are parts. 2. Parts also can be sold seperately. car -25000 brakes 300.00 3 Prices for each part or systems is different for each and every customers. customer X - car 1 - price 24000 , customer y car 1 price 23000 4. Each customer will have a price contract every year and the contracts may be released earlier. but while quoting the pricing should be picked up according to the contract period All I need is just the database- open for suggestion regarding views and procedures-
Project ID: 13581334

About the project

23 proposals
Remote project
Active 7 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
23 freelancers are bidding on average $162 AUD for this job
User Avatar
Hello There I think I can help you out to achieve this task. Please PM just to verify the scope and few example of the system. Thanks and regards
$155 AUD in 6 days
4.9 (24 reviews)
5.7
5.7
User Avatar
I am interested in this job and available today to do this. let me know if you are interested in my profile. looking forward to hearing from you.
$111 AUD in 2 days
4.9 (35 reviews)
5.0
5.0
User Avatar
A proposal has not yet been provided
$222 AUD in 5 days
4.8 (42 reviews)
5.0
5.0
User Avatar
HI, I have 15+ years experience in SQL design, development and performance optimization in database platforms such as MSSQL, Sybase ASE and MySQL what db platform you are planning to use? MySQL? you have mentioned systems can be supplied as one lot or in two stages. is this predefined for a given system or depends on the business need? ie same system can be supplied in one lot or in stages. however assume that stage constituent products are pre-defined and not variable can we assume that system price same as sum of all constituent product prices. are you trying to build order management system? hope to hear from you regards Babu
$192 AUD in 5 days
5.0 (2 reviews)
3.6
3.6
User Avatar
hi. i have a lot of experience databse design. i can easily complete this project for you. we can have a chat. thanks
$120 AUD in 3 days
5.0 (5 reviews)
3.6
3.6
User Avatar
Hi, Hope you are doing well today. I am freelancer having 100% completion rate and 98% of client satisfaction. I understand the importance of well-researched designing or website development solutions and fully practice them. For your satisfaction kindly visit our profile, check feedback of clients and previous work: https://www.freelancer.pk/u/ZulqarnainAwan89.html?page=portfolio Graphic Design Skills and tools 4. Adobe Photoshop (Image manipulation, Image Editing, Creating Actions and many more) 5. Adobe Illustrator (All kind of vector graphics and illustrations) 6. Adobe InDesign (Graphic Document management tool) Web Development tools and skills 3. Google web designer 4. Net beans IDE HTML5, CSS3, JQuery3.1, PHP 7 NOTE: CHECK MY BID I AM PHP CERTIFIED AND CUSTOM CODER Best Regards findSkilled
$155 AUD in 3 days
4.6 (1 review)
3.4
3.4
User Avatar
Good morning. I do understand that you would like to get a Mysql database created. Went through the details provided. Would like to know little bit more details regarding the number of cars that you sell or the number of components that it will have. Also an important aspect regarding for how many customer/client is expected over a period of time. One more aspect is the kind of things that you would like to see in the database, From the details, i am concluding it to be more or less Cars and their parts, but yes not knowing the extend of the components that you will be selling. One more aspect is that the component prices are not constant and it varies based on the customer. Would like to know whether this is due to some discounts being given to regular customers or for some other reason so that database can have such a provision. Also we may need to discuss more about shipping details to figure out the details that will be required to be added ex: Who does the shipping etc We could discuss it when you have the time. Thank you.
$133 AUD in 4 days
5.0 (5 reviews)
2.6
2.6
User Avatar
Hello, I’ve carefully gone through your job posting. I ’m an expert in web developement with more than 3 years experiences with Oracle PL\ SQL and .Net . I am very much interested in your project with all of your requirements. I have developed “Inventory Erp” , “HR” , “Leasing” , “Hotels reservation” , “Medical Analysis” , “POS” I have developed this web apps using Oracle PL\SQL , Oracle SQL , asp.net mvc,sql server database,html,bootstrap,angular js,jquery,ajax,json For more on my skill and successfully finished jobs, I am always available on Skype. Thank you for your consideration Best Regards Omar Rabie
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello.. I Would like to help u in design the database Accordingly and get the way to be done asap..Plz let me the things which u wana build up on the database and i am sure i will do my best to complete at time at ur convience
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A student from the University of Melbourne. I am good at Database design. No matter what kind of database you want(SQL or No-SQL), I can design for you fast with a high quality.
$111 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm a fresh graduate from big data department. I was worked in Information System Development agency in previous work. If you have question, please contact me. Thank you
$144 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I got the requirement and can design this database to help you automate pricing. I can also write code to get desired output. I can also make the design flexible for future design changes, audit and dashboard reports. I have experience in designing databases to Fortune 500 clients. I handled databases of Cisco, Owens & minor, Microsoft, sports-betting, Citibank, TELUS and Bank of Montreal. Thanks, Kiran.
$200 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have 6+years of experience in designing Data bases. and have functional knowledge on retail things. as your work seems to more like retail where you have different items and customers. i can assure that i can design the most efficient Data base and and suggest you regarding the procedures and views. looking forward to work with you. Cheers, Ravi teja
$133 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have much experience with SQL and MySQL in particular. Seems like a straight forward design. One thing wasn't clear to me: "price for each product = cst price + mark up percent + extra value + gst". So, I suppose cst price is fixed, then markup is different per customer/contract. And what are extra value and gst (are these per customer or fixed per product)? If interested in working together, please contact me. Thank you.
$250 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Cranbourne North, Australia
0.0
0
Member since Nov 14, 2011

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.