Search the data in the table in sql server to find if that column is Numeric or Nominal or Ordinal.
All the column names in the table are of datatype "varchar".
1. First display list of all columns in that table.
1. If the Column data is Numeric then change its datatype to Numeric from Varchar or if Its Nominal(character) then you dont have to change its datatype but you just have to display it as Nominal on the webpage.
coming to ordinal, ordianl data is the set of integers. For example a column contains values 0, 1, 2 the we can take it as ordinal as o--bad, 1--good, 2 -verygood.
But user will mention if a column is ordinal or not. If user mention a column as ordinal then that column is nothing but Numeric only so you dont have to change its datatype but you have to display it on the webpage. All the remaining operations will be same for Numeric and ordinal.
2. If a column is Numeric Then you have to find [login to view URL], [login to view URL], [login to view URL] count, [login to view URL], [login to view URL] deviation [login to view URL] of nulls("null","NULL","Null", " ", "?").
3. If a column is Nominal then you have to find [login to view URL] count, [login to view URL] count, [login to view URL] of Nulls("null","NULL","Null", " ", "?").
4. If ordinal then Everything is same as Numeric as ordinal is nothing but set of integers.
The WEBPAGE should look like this:
It should have only one page(optional)
first page: 1. show all the column names from table with check boxes, on the left side of the page.
3. In the same page, user should have an option to mention if a column is ordinal, then you should to be able to display it as ordinal.
2. when the user checks a box (or clicks that column name), Then on the right side of the page it should show what kind of data it is.(Nominal/Numeric/ordinal).
3. Then below that it should show the functions i mentioned in the bid request for each column(min, max, distinct count).
## Deliverables
It should be able to run in VS2005 and sql server 2005.
It should be an ASP.Net application but the codebehind should be in C#
Let me give one example:
If there is a table with name "userdata".
Example table userdata:
name num race
ak 2 1
null 5 2
cc 6 3
Initially in the table structure everything is varchar.
First display all the column names as name
num
race
1. According to data name(char), num(numeric), race(numeric).
2. So change the datatype to Numaric for "num" and "race". But name is varchar so keep its datatype as it is.
3. But here "race" maybe ordinal as( its a set of integers {1,2,3}). so if the user mentions it as ordinal then you have to display it as ordinal.
4. Now if user clicks on "name" or ckeckbox is checked then display distinct count, nulls.
5. for "num" display Min, Max, Avg. Mean, Std deviation, distinct count and number of nulls.
6. for "race" the diffrence is that it is ordinal but all the operations will be same as numeric.
## Platform
C#.Net Web Application