I'm in the process of building a database which we'll eventually host on AWS.
Part of the project is building tables to manage data for courses that we run.
Each course can comprise of anywhere between 2 to 22 days which are not consecutive.
We need to be able to set the dates and start and end times for each day of the course.
Are repeating fields the best approach for this?