Create a process that loads the donation CSV files into the Central Donation Repository. Your process must allow for any number of CSV input files to accommodate any number of volunteer leaders. The process must ensure that the Central Donation Repository contains no bad data $--$ only valid donation entries should be inserted into the Repository.

Your process must be repeatable. That is$,$ it must be able to be re$-$run without generating any errors.

Donation entries must be rejected in the following cases, if they:

have invalid addresses $($i$.$e$.$ they do not exist in the master table$)$

have invalid postal codes according to Canada Post

have duplicate names in one group's project

have $50\%$ or more duplicate names from other groups

have either name from donorsList.csv

have a date out of range $($current date to $3$ months prior$)$

have a volunteer id outside of the leader's group

have nulls in the mandatory $($NOT NULL$)$ columns in the Repository

Your process must produce one CSV file of rejected entries for each volunteer leader. Each volunteer leader's file should contain entries for only their volunteers.

he list of donors and donations is stored in a comma$-$separated file $($referred to as CSV or $.$csv$).$ A sample named donorsList.csv shows a list that each volunteer group leader sends to the main office for processing. Each student in your group will act as volunteer leader and will create test data for their area based on the donorList.csv format. The column headings, number of columns and formatting within each column is not to be changed and must be used exactly as shown.

Your group must provide a total of $60$ distinct donor names and valid addresses evenly split across at least $3$ separate CSV files. The $60$ donations are required regardless of the number of how many students are in your group. DO NOT USE EITHER OF THE SAMPLE ENTRIES in your submitted CSV files.

In making up your fictitious donations and your donorList CSV files, also consider the following:

One volunteer's donation area should consist of no more than two adjacent postal codes.

Each volunteer leader should have donations from no more than $6$ postal codes.

Each volunteer leader will need an appropriate record in the volunteer table. Refer to the script projectTables.sql for details.

Each CSV file should contain both valid and invalid entries, which is described later.