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]
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
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.
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.
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