Need to create a relational database design for managing online court booking system.
Developer will have to come up with full list of tables along with relationship among them and also Mysql queries to create these tables.
database should be designed to answer following queries efficiently
1. find all the available courts for a particular sports in an area for a given time slot range
2. find all users who have opted for a particular sports in a club in a given time slot range.