Calculate attendance based on days of the week

I would like to store in an Oracle database which users are in the company on which days of the week (Monday to Friday). These times can differ on odd and even weeks. E.g. User 1 is always at work Monday and Friday for the week. User 2 is available on evenings Monday and Wednesday and on odd weeks only on Fridays.

Now I just want to be shown who is at work on July 9, 2021, for example.

Which database scheme would be recommended here and are there solutions to query the above question at the database level?

submitted by /u/Spektralist
[link] [comments]


Go to Source of this post
Author Of this post: /u/Spektralist
Title Of post: Calculate attendance based on days of the week
Author Link: {authorlink}