Multi one-to-many, one-to-one relational questions
I've got 3 tables and I am not sure how I should be relating/connecting them. They are Properties, Leases and Tenants and I would like the following:
One property can have many leases and many tenants.
One lease can only have one property and one tenant.
One tenant can have many leases and many properties.
Can someone show me how this will look with the relational database? I want to make sure it's all right before moving forward.