Use C# to design and build the following application

Use the format to create 2 CSV file, read them by File IO

HogWit University (HWS) is a new university just starting in the western suburbs. They have hired your company to develop a system for counseling students on the courses they need to graduate. The app should input a student ID number and then display the student name, their major, the number of completed courses and the required courses they need to complete. As they prepare to open their doors, they are a liberal arts university and therefore only have 1 major: GenEd. Here is their current catalog:

This data should be input as a CSV file with this format.

Id	Topic	Description	Prerequisite	Type of Class
His101	History	History of Magic and Muggles	None	Required
Eng101	English	Introduction to English	None	Required
Eng102	English	English Writing	English101	Required
Mat101	Mathematics	College Algebra	None	Required
Mat202	Mathematics	Calculus 1	Mat101	Required
Her101	Herbology	Introduction to Herbs for spells	Mat101, Eng101	Required
Cha101	Charms	Introduction to Charms	None	Required
Dark191	Dark Arts	Introduction to the Dark Art	None	Required
Mug101	Muggle Studies	Introduction to Muggles	None	Elective
Alc101	Alchemy	Introduction to Alchemy	None	Elective
Mus101	Music	Introduction to Music	None	Elective

Here is their rule for graduation from their catalog: Students must complete at least all of the required courses and 2 of the electives.

Here is their current enrollment. Some of these students are transferring in and therefore have credit for completed courses. The following data will be imported as a CSV file.

Id	First	Last	Courses Completed
S101	Harry	PotSome	Eng101,Eng102,Eng103,Her101
S102	Tom	Raddler	Eng101,Cha101,Eng102
S103	Janice	Joplin	Mus101,Eng101,His101,
S104	Nelly	Newbie
S105	Ryan	Ready	Eng101,Eng102,Mat101,Math102,Her101,His101,Cha101
S106	Sammie	Starter	Mus101

Write a program that reads the CSV file, sorting and show the required courses and student records.

then:

• Prompts the user for student id.
• If the records is found then output the total required courses, total electives and the required courses the student completed and then the electives that the student completed.

For example ..

The output will show the student id and name and then the course counts:

What Student Id are you interested in? S101 Student with id:S101 is there ------ Record for First:Harry Last:PotSome id:S101 ------ ------ Regured Courses Reg:8 Elect Required:3 Required Compl:3 Elec Compl:0 what Student Id are you interested in