One of the many tasks that programmers get asked to do is to convert data from one form to another. Frequently data is presented to users in well-labelled, tabular form for easy reading. However, it is impossible or very difficult to do further processing of the data unless it is changed into a more useful form.
For the purposes of this assignment I have downloaded and will make available the undergraduate applications to the 37 Australian universities from the Department of Education for 2009 - 2013 data file as a text file.
Your program will load this data into an array of structs, save the data in a form that is directly usable by a database (see below), display the data on the console in its original form and in its database form. It will also allow the user to display the highest number of applications for a given state and year.
Your program will use a menu to allow the user to choose what task is to be done. You will only be required to handle the Applications data. You can ignore the Offers and Offers rates data (see below).
1) Write a method to display instructions to the user
2) Write the code to display a menu and test it
3) Write the code to display the contents of the data file line by line
4) Write the code to save the contents of the data file to a new file
5) Write the code to copy the file data into a simple array of structs where the structure is something like:
6) Write the code to deal with the unnecessary data at the start
7) Write the code to deal with the unnecessary data at the end
8) Write the code to modify the code to convert the original data into database format. You do not have to follow the exact structure given above, e.g. you could use commas instead of tabs You may want to divide this into two problems. First treat the numbers as a string, i.e. New South Wales, Charles Sturt University,"3,769" and when you have that working then work out how to convert "3,769" into 3769 etc
9) Modify the struct to handle the modified data
10) Modify the file save code so that is saves the modified data
11) Write the code to find the highest number of applications in a year for a state.
Attachment:- under graduate application.txt