Right now, I am using a static class to contain all the information. My plan is for every database, the program will generate a text file to contain all the information.
The following information will be stored in the database
Database1: Weekend start date, weekend end date, weekend number
Database2: Event name, start time, end time, teachers in charge, back up teacher, location, transportation, kitchen request, notes
Those two database will be independent from each other so that a weekend event could be generated before the weekend being initialized in database1.
Because of these two being independent from each other, each time viewing events for a particular weekend, there will be calculations needed to decided which events belongs to which weekend.