Find Jobs
Hire Freelancers

Database Table Normilization

$10-30 USD

Cerrado
Publicado hace alrededor de 5 años

$10-30 USD

Pagado a la entrega
Hi - I have taken over a Database from a co-worker who has stopped showing up for work and I feel the this database is a nightmare. The table structure is non existent and while what was originally set-up "works" - it is not easily understood nor "correct". For example, this is DDL for two tables - that I feel should actually be broken down into multiple smaller tables, what do you guys think here? For example, we have the table HSN New which duplicates data from HSN, but has an active column to show if the info is active or not. To me the best set-up would be to have a table for MSN, SN (which is master site name, site name, and active). Then have a table with a Auto-Number PK and a FK that links back to MSN that has (ID, FKMSN, RN), Then have a table with a Auto-Number PK and a FK for the 'other' non connected data (ID, FKMSN, DQ, Email), and lastly a table for the MT - set-up like this (ID, FKMSN, MT). Essentially everything links back to the MasterStoreNumber in the what I'll call Main table. This is how the current DDL is set-up, I know it's a cluster. What do you guys think? This is a link to a subset of data and DDL [login to view URL]
ID del proyecto: 18783275

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 5 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
13 freelancers están ofertando un promedio de $47 USD por este trabajo
Avatar del usuario
I have experience of 4 years.I can complete your work as per your requirement and deliver it on time. Assign me and get quality of work on time Thanks
$35 USD en 1 día
4,4 (18 comentarios)
4,1
4,1
Avatar del usuario
Hello Sir, I can normalize you database and finish it till tomorrow. Just let s have a chat and tell me more about it. Thanks, Alex
$30 USD en 1 día
5,0 (2 comentarios)
2,8
2,8
Avatar del usuario
hi i read all instruction please share more detail i did similar 5 task i will provide 5 star rating work thanks
$50 USD en 1 día
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
Hello , Greetings !!! I just read your Project Description and i m willing to go ahead and start Development on this Project Table normalization . I have done this kind of project recently i can give you this Project in real quick time. I have 10 year working experience on multiple Database Project based on MS SQL server, mysql and Oracle. i will work in Strategic milestones and transparency so that you will be frequently uploaded on where we stand in the project i can achieve the result that you are looking . Looking forward to hearing at your earliest convenience. Thank you Avin Pawar
$25 USD en 1 día
5,0 (2 comentarios)
1,2
1,2
Avatar del usuario
Hello, dear manager. I think your word is make sense. And also I think that you want is just reorganization of table. I can finish in 1 day. I will wait your response. Best regards, thanks, Anne.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi I have read your project description and I can deliver your work to expectations. I have 3 + years on SQL and database programming
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
These people bidding bidding $25 are nuts. If you want this done right, I'm your guy. I do agree that this should be multiple tables and possibly even foreign keys. Can you confirm that this is a Microsoft SQL Server database? Your ad never mentioned the specific type of data (you should NEVER post without this information) I bid $250 because I cannot tell how big of a project this is from your ad. I am open to lowering this if it really is a simple project, but I can't tell from your ad, we would need to talk.
$250 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, As gone through it we can do your work and delivered to you on time. Please assign this task to us.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Seems like your database isn’t normalized correctly. I can assist here. I’m a Microsoft SQL Server Certified MCP DBA & Developer with a passion for BI and Data. Experienced Sql Server Consultant with a demonstrated history of working in the information technology and financial services industry over the last 12 years. Skilled in Advanced TSQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Migration, Data Warehousing, Powershell Scripting, as well as a strong aptitude in C# .Net and Object Orientated principles. Proficient information technology professional with a Bachelor of Science - BSc. focused in Computer Science
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
20+ years of experience with SQL Server database design and development, Developed hundreds of databases. Designed Datamarts and Datawarehouse
$40 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Athens, United States
0,0
0
Miembro desde feb 21, 2019

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.