AnsweredAssumed Answered

Multi one-to-many, one-to-one relational questions

Question asked by JohhnyHilly on Sep 14, 2014
Latest reply on Sep 14, 2014 by SteveMartino

Title

Multi one-to-many, one-to-one relational questions

Post

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.

Outcomes