Find Jobs
Hire Freelancers

Database schema design for one table

$10-30 USD

Closed
Posted over 10 years ago

$10-30 USD

Paid on delivery
I need someone to design a database schema for me. I have a database of products that look somewhat like this: - product1 > red, blue, green, polyester, wool - product2 > small, medium, large and I need to figure out a way of storing a unique SKU # for each combination. So for product one there will be 6 different combinations and for product 2 there will be 3 different combinations. (there is no limit to how many combination a product may have) I have the question explained much better here: [login to view URL]
Project ID: 4995199

About the project

29 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
29 freelancers are bidding on average $30 USD for this job
User Avatar
Hello, sir I'm interested with your project. I'll do it for you. I can do it well more than you can think. :) Regards.
$53 USD in 0 day
4.9 (209 reviews)
9.0
9.0
User Avatar
Hey I am Software Engineer. I have designed many Schemas for databases (I can show my previous work ON DEMAND). Contact me as soon as possible. I can help you. Regards. Junaid
$25 USD in 1 day
5.0 (39 reviews)
6.4
6.4
User Avatar
Hi there, I have over 7 years experience working on HTML, Wordpress, Magento, Database administration, OpenCart, Website Design, Logo / Banner Design Joomla, CSS and Linux Administration. I have read the project description very well, and i would like to complete this project. lets complete this project
$31 USD in 2 days
4.7 (116 reviews)
6.5
6.5
User Avatar
Dear Sir, I am Database Professional Software Developer, I can Handle your job and do everything extremely Grate. Regards,
$54 USD in 4 days
4.9 (22 reviews)
5.7
5.7
User Avatar
Hi, I'm very interested helping you designing your database schema, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this (I've attached an example of ERD done here in my portfolio). Please send me all other details about your tables, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$50 USD in 1 day
4.6 (42 reviews)
5.5
5.5
User Avatar
1. Knowledge in different Linux/Unix distribution such as CentOS, Debian,FreeBSD, Solaris and other open source application like Bind, qmail, postfix, squid, apache, samba, pro-ftp, iptables, ipf, postgresql, jboss, apache tomcat, mysql, ruby and Asterisk VOIP system. 2. Implementation of application server such as Tomcat and Jboss, with loadbalancing features. 3. Knowledge in installation and configuration of wired and wireless LAN. 4. Planning of network cabling installation and termination. 5. Proficient in any windows operating system platform. 6. Knowledge in Server Management, antivirus configuration, firewall, domain controller and active directory. 7. Experience in configuring MS windows server 2000 and 2003 OS and basic understanding in Mac operating system. 8. Server and Network Monitoring tool implementation such as mrtg, nagios, zabbix, and awstat. 9. Virtualization installation and management such as openvz and vmware. 10. Virtualization using VPS, Open VZ, and KVM. 11. Automation of server build and configurations using puppet.
$30 USD in 3 days
5.0 (3 reviews)
4.8
4.8
User Avatar
I am interested on this project. Let me know the details. I have more than 10 years experience in Database administration and design. Thanks.
$29 USD in 3 days
4.9 (38 reviews)
5.0
5.0
User Avatar
I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion (Adobe and Railo)
$55 USD in 1 day
5.0 (7 reviews)
4.4
4.4
User Avatar
Hi This is bhargava . i am expert in data base design . I am already completed your task . I am ready to send it to you . please select my bid if u like the my design . please check pm for more details
$30 USD in 0 day
4.9 (31 reviews)
4.3
4.3
User Avatar
Hi This is a fairly simple piece of work. I can also include the SQL code to create the table for you if you need. All the best, Ben
$20 USD in 3 days
5.0 (3 reviews)
3.9
3.9
User Avatar
Basic idea is to have a variant_id and a value_id. You then have another table that contains given a variant_id of 1 - color, 2 - material, and 3 - size (and your value_id is unique to the varian_id from stackoverflow), you get: product_id variant_id value_id price 1 1 1 $$$ 1 1 2 $$$ 1 1 3 $$$ 1 2 1 $$$ 1 2 2 $$$ 1 2 3 $$$ 2 3 1 $$$ 2 3 2 $$$ 2 3 3 $$$
$30 USD in 0 day
5.0 (2 reviews)
3.2
3.2
User Avatar
I have carefully read all explanations on indicated website and, based on my good experience, the knowledges that I have and previously database designs that I made, I can do this task on a very short time. Looking forward starting the work, Doina
$25 USD in 1 day
5.0 (2 reviews)
2.0
2.0
User Avatar
Hi, Hope you find this message in good health. I have done masters in computer science. I have got 5+ years of experience working with MNCs of CMMi level 5 companies including Siemens and 7+ years of work experience in freelancing. I have very strong knowledge of software design, principles, diagrams, SOA architecture, Database architecture etc. I do possess below skill set:C#.NET, ASP.NET, WCF, WPF, SQL Server, MySQL, VC++, VB6. I can design this table right away. Hope to hear from you soon. Thanks!
$30 USD in 1 day
5.0 (5 reviews)
2.0
2.0
User Avatar
Dear Customer! I am an expert PHP and Open source developer with over 5 years of experience and really interested in taking up this project. Available to start immediately and finish as soon as possible. My bid is for professional and efficient services to my customer. Drop me note and i will be available. Best Regards, Manu
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having experience in creation and management of databases mainly related to big finance data. Oracle certified administrator.
$15 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Well, i think that you can separate them into several tables and let the SQL does the cross product or in other words gets the total combination instead of you doing that :) and i have the schema if you want to see it :) Thanks in advance :)
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , It is very simple to design , let me need to understand your business requirement , then only can go further decide about this schema definition , before that taking decision to change this schema is not a good idea , i hope its very simple & easy to design. we can easily complete this !!! Will discuss this to complete this successfully !!! Thanks !
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i have looked thoroughly your requirement.... & i m sure i Can create the exact table Matching your Requirement,, and I can also Create a Trigger that will automatically insert values into your "Final Required Table" (which is having "combination[SKU]" column),,, Means when one insert values into "products_variants" table, it will automatically insert the record accordingly into your "Final Required Table" which contain 'combination' column ..... Means UNIQUE value for combination[SKU] column will b generated automatically and will be inserted according to the given input...... and {{ OPTIONAL== In case if u want to improve your existing table structure, I can Suggest you a Better structure for your existing tables also.... }}
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Data modeled several times. This is a very well known area. I can help. 3NF model for Products generalized with Variants and Items can work. I can explain if you contact.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have worked with database architecture earlier. I can work on normalization of your database. Please let me do it. It will help me earn some money and help your get your work done in no time. I have read through your explanation in stackoverflow, I have the following doubts, 1. Are there no size descriptions for the rugs? 2. Is there no Color description for the cups? In case these features are also incorporated, it would add more SKU to your product line, and make the database much easier to handle. Hoping to hear back from you. Thanks
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Bellerose, United States
5.0
1
Payment method verified
Member since Oct 8, 2008

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.