Create an XML file holding expenses by vendor and month.
Create new tables and relationships to keep the expenses by period in your SQL Server database.
Write a C# program to read the XML file, parse it and save the data in the SQL Server database.
Input: XML file holding expenses by vendors by months.
Output: program for loading an XML expense report in SQL Server; data loaded in the SQL Server database.
Input: XML file holding expenses by vendors by months. Output: program for loading an XML expense report in SQL Server; data loaded in the SQL Server database.