Using Visual Basic ALREADY COMPLETED PART A AND C . PLEASE HELP WITH PART B.

U.S. SenateThe file Senate113.txt contains the members of the 113th U.S. Senatethat is, the Senate prior to the November 2014 election. Each record of the file consists of three fieldsname, state, and party affiliation.2 Some records in the file are as follows:

2We refer to anyone who is neither a Republican nor a Democrat as Independent.

Richard Shelby,Alabama,R Bernard Sanders,Vermont,I Kristen Gillibrand,New York,D

The file RetiredSen.txt contains the records from the file Senate113.txt for senators who left the Senate after the November 2014 election due to retirement, defeat, death, or resignation. Some records in the file are as follows:

John Rockefeller,West Virginia,D Tom Coburn,Oklahoma,R Carl Levin,Michigan,D

The file NewSen.txt contains records for the senators who were newly elected in November 2014 or who were appointed to fill the seats of senators who left after the 2014 election. Some records in the file are as follows:

Shelly Capito,West Virginia,R Steve Daines,Montana,R Gary Peters,Michigan,D

A. Write a program that uses the three files above to create the file Senate114.txt that contains records (each consisting of three fields) for the members of the 114th Senate where the members are ordered by state. Use this file in parts (b), (c), and (d).

B. Write a program that determines the number of senators of each party affiliation. See Fig. 8.38.

U.S. Senate U.S. Senate- X Count Party Affiliations Democrats: 44 Republicans: 54 Independents: 2