Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: The actual Database software does not matter to me, so long as I can purchase a licence for it at a reasonable cost - I'm just using a laptop. There is at least 1Gb of data I have (large CSV file) from the website below that lists every car currently registered on the roads in NZ and many details about each one. The database is to be single user access, and I don't need any fancy GUI front end, just a way of getting the raw numbers out of it.
My primary interest is to be able to get histogram style statistics out of it such as:
Number of cars manufactured between 1850 and 1950 on the road? Between 1951-1960? Between 1961-1970?
How many high performance cars (I can provide a list of brands) are on the road? Where are they all located?
How many Ferrari's are on the road? Where are they all located? What is the most popular model type? Engine size?
I'm trying to use these kinds of statistics to estimate demand for some automotive products that are targeted at the classic and high performance road car market. If I know how many cars in total (total market size) what brands of cars and where in the country they are located, I can focus my sales efforts. A full breakdown of required query information can be provided.
Mark M.0% (0)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Can you please say what type of queries you require that can not be done by loading the data into an excel spreadsheet and using a data filter.
Can you please let me know how rigid is your less than 1 week deadline? Depending upon the number/kind of queries that need to be developed, it may take more time for an individual developer like me and hence the question. Thanks.