This blog post could be helpful for those who seek a way to store and retrieve all appointments information like Resources, TimeMarkers, Categories. It also provides a handy way to handle recurrence exceptions without any additional code.

1. Database design (This step can be avoided if a DataModel is initially created and then a database is generated from it).

The key points that need to be taken into consideration when planning the database are:

• Where to save appointments
• Where to save recurrent appointments’ exceptions
• Where to save resources and how to relate them with appointments

Here is the database schema used in...