Data Normalization in SQL Server and C#
$750-1500 USD
Bezahlt bei Lieferung
You must have strong C# and SQL Server Skills as well as relational database and data normalization experience in order to be considered for this project.
I need an application that will allow me to standardize the data in my SQL Server database by using specific rules. The application will take a table as input and convert that table into multiple tables based on the rules set within the application. The application will also build a table of conversion relationships that it will use to learn from as the user converts data.
Have you ever seen a database that has a column with data in it that is all the same but spelled differently or formatted different? For example I have a table that has a column called 'Currency' but the data in that column there are many versions of the same currency:
Dollars
USD
US Dollars
$
Dollar
us dollars
US $
Now in a database this is a big problem. I want you to create a C# application that takes SQL Server tables as input and creates or adds to other tables the standardized data. So in this example the user will select a matching 'Currency' value to match to each one of these values above. So if the user were to select 'USD' as the standardized value then in the new table there would only be one version of the currency for US dollars.
USD
Once the user has imported data numerous times the Conversion Table will have many matches for USD so the next import may be completely automatic. There will be many imports so the system must learn from previous imports so that the user will need to do very little work in future imports. Once the system learns all matches that are relevant for USD then the system will not need to ask the user how to match certain columns, the system will simply match the data itself and create the new table automatically.
After the data is standardized the system automatically will match the new 'Type' with the types in the normalized database. This is done so that the value 'USD' does not need to be in the database thousands of times, instead a Type ID will be used, such as an integer. This will link to the 'Type' table.
See the attachments for more details.
If this makes sense to you then please answer the following questions. I will select the winner based on the answers to the following questions:
1. Explain what I mean when I say 'once the system learns'. How does the system that you are creating learn how to select the standardized format for the data being imported? (refer to the attachments)
2. What are the green cells in the attached spreadsheet? Why are they colored green?
3. Why do I want the final output table to have integers as ID's for the normalized data instead of the actual value such as 'USD' or 'AP'?
Projekt-ID: #915338
Über das Projekt
Vergeben an:
Hi, I have well expeirence in c# and SQL server. Please check you PM. Thank you. Regards Arun
35 Freelancer bieten im Durchschnitt $834 für diesen Job
I'm planning for doing this - Study the current system: 2days - Developing: 13 days - Testing: 4 days - Delivering/supporting: 1days
i am Micro Soft certified professional in C# and SQL2005. i have more than 10 years of experience .please contact for good work.
Hi, .NET developer with 6 years of experinece is ready to help you. Please check PMB for details. Thanks Japaj
Hi, I can develop the required c# application for you that will execute the required operations of standarization, import etc on the SQL Server database.
i saw your project and this project consists the my skills so i can complete this project within 5 days.....
Hi, we are Software and IT firm with 12 years of experience. We specialize in VB.Net, C#, SQL Sever and Oracle development. Please check PMB
Hi, we are a team with over 10 years experience in web development and have already worked on several complex, high availability projects that required massive, optimized databases. Please see PMB for details.