One of the images show an example of how a relational schema should look like as it needs to show how all tables are related via their foreign keys.

I have also provided an image of an ER diagram I've created. Below it, is the relational schema based on the ER diagram.

I am not sure how to connect them as some of them either don't have foreign keys or they all connect to the member table.

I would like for you to review my ER diagram and guide me on how I can make changes so I can be able to connect them all and create a relational schema. Please show me how you would connect them and what changes you would make for the ER diagram and relational schema to look its best.

I would like not for everything to be connected to the member table, try to find connections within the tables.

Relational Schema Example [A relational schema shows all