Find Jobs
Hire Freelancers

Database schema design for one table

$10-30 USD

Cerrado
Publicado hace más de 10 años

$10-30 USD

Pagado a la entrega
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]
ID del proyecto: 4995199

Información sobre el proyecto

29 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
29 freelancers están ofertando un promedio de $30 USD por este trabajo
Avatar del usuario
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 en 0 día
4,9 (209 comentarios)
9,0
9,0
Avatar del usuario
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 en 1 día
5,0 (39 comentarios)
6,4
6,4
Avatar del usuario
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 en 2 días
4,7 (116 comentarios)
6,5
6,5
Avatar del usuario
Dear Sir, I am Database Professional Software Developer, I can Handle your job and do everything extremely Grate. Regards,
$54 USD en 4 días
4,9 (22 comentarios)
5,7
5,7
Avatar del usuario
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 en 1 día
4,6 (42 comentarios)
5,5
5,5
Avatar del usuario
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 en 3 días
5,0 (3 comentarios)
4,8
4,8
Avatar del usuario
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 en 3 días
4,9 (38 comentarios)
5,0
5,0
Avatar del usuario
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 en 1 día
5,0 (7 comentarios)
4,4
4,4
Avatar del usuario
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 en 0 día
4,9 (31 comentarios)
4,3
4,3
Avatar del usuario
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 en 3 días
5,0 (3 comentarios)
3,9
3,9
Avatar del usuario
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 en 0 día
5,0 (2 comentarios)
3,2
3,2
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
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 en 1 día
5,0 (5 comentarios)
2,0
2,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Having experience in creation and management of databases mainly related to big finance data. Oracle certified administrator.
$15 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Bellerose, United States
5,0
1
Forma de pago verificada
Miembro desde oct 8, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.