Закрыт

Database Table Normilization

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]

Квалификация: Управление базами данных, Программирование баз данных, SQL, T-SQL (Transact Structures Query Language)

Показать больше normalization in database with example pdf, normalization definition, data normalization techniques, normalization example, normalization in dbms with examples pdf, database normalization for dummies, normalization example with solution, normalization in database with example tables, variable number column database table, php can display database table row column, jsf database table column number, convert xml column to table sql server, mysql link column to another table, wordpress export database table to csv, laravel migration add column to existing table, how to copy data from one database table to another database table in sql server 2008, sql copy data from one column to another in different table, android sqlite add column to existing table, insert data from one database table to another database table in mysql, sql copy data from one column to another in same table

О работодателе:
( 0 отзыв(-а, -ов) ) Athens, United States

ID проекта: #18783275

15 фрилансеров(-а) в среднем готовы выполнить эту работу за $46

bspanovic

I CHECK TABLES. THEY ARE FLAT TABLES WITHOUT PRIMARY KEY OR INDEXES. ALSO, I BELIEVE THAT NO NORMALIZATION IS DONE ON TABLES. FOR MORE I NEED TO KNOW MORE ABOUT THE TABLES CONTENT AND USE. My name is Spanovic Borut Больше

$30 USD за 1 день
(10 отзывов(-а))
5.4
dhanuitdevendra

Hello, Hope you are doing well! We can help you with our Data Architect as a Service (ARCaaS). Please visit [login to view URL] for details. Please have a look at our existing customer base Больше

$50 USD за 1 день
(3 отзывов(-а))
4.2
rashmisingh2990

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 за 1 день
(16 отзывов(-а))
4.0
iosif2455

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 за 1 день
(2 отзывов(-а))
2.1
mukesh30march

hi i read all instruction please share more detail i did similar 5 task i will provide 5 star rating work thanks

$50 USD за 1 день
(1 отзыв)
1.1
avinpanwar300

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 Больше

$25 USD за 1 день
(2 отзывов(-а))
1.2
fairysmile324

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 за 1 день
(0 отзывов(-а))
0.0
Tahawor

Sir i somehow get your points by your link which you are mentioned in your description. First of all (N'A Central', N'Ron Burgandy', N'[login to view URL]', N'RLD-HDL-BCS') these data are making problem. These are the r Больше

$25 USD за 1 день
(0 отзывов(-а))
0.0
samwelanderson

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 за 1 день
(0 отзывов(-а))
0.0
$25 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
vw2130926vw

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 Ser Больше

$250 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
CitachiTech

Hi, Good Evening ! How are you? I see that you are in need of a Database Expert for this project. I am Hardik Kotecha. I have close to 13 years of experience in the field of Database Management and Web Developme Больше

$40 USD за 1 день
(0 отзывов(-а))
0.0
dvnasoftech

Hi, As gone through it we can do your work and delivered to you on time. Please assign this task to us.

$25 USD за 1 день
(0 отзывов(-а))
0.0
rvieira55312

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 hi Больше

$15 USD за 1 день
(0 отзывов(-а))
0.0
JacobMilter

20+ years of experience with SQL Server database design and development, Developed hundreds of databases. Designed Datamarts and Datawarehouse

$40 USD за 3 дней(-я)
(0 отзывов(-а))
0.0