I am currently learning database modelling and struggling to model the following requirement. I have a
sports_club table. User can only join a
sports_club if three existing users of the club approve his request. If the number of members in club are less than three then all the existing members (whatever 2, 1 ) need to approve his request. My table looks something like this:
I am struggling to model this approval process in my database? Could anyone help me here? Sports club can have any number of users.