I have trouble wrapping my head around a database I’m building for a client.
The concerned DB is for equipment rentals and my problem is making clear what’s available at a given date for rental. In the Rental table, I have a field for the outing date and another for the return. When a new rental is made, we would need to enter specific in/out dates and see the equipment available for those dates.
Any idea on this?