sql developer

Address,DonorName,Date,Time,Amount,Type,VolunteerID

$232$ King St$.$ East Toronto ON$,$Sally Field,Oct $212023,10$:$00$ AM$,20,$Cheque,$241$

$333$ Flats Height N$.$ Ontario,Sergio Aguerro,Oct $212023,11$:$00$ AM$,10,$Cash,$241$

fact.

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