I am working on my school project to create an eCommerce website that sell and rent product.
My main problem is that I can't find the best design for the "Renting" part. For now I am thinking about two designs:
The first database design suggestion:
The second database design suggestion:
As you can see there are the same tables in both designs but with different relations, but I can't tell which one is better.
I will be happy if you can tell me which design is better or if there is a better way to design my database altogether.