I am struggling to get my head around allowing multiple hires in my rental database I am doing for school.
note: all copies of media have individual LibraryID even multiple copies
I have a transaction table and a hire table as follows;
:Transaction:
TransactionID PK
DateHired
DateDue
DateReturned
CustomerID FK
HireID FK
:Hire:
HireID PK
LibraryID FK
TransactionID FK
:Library: and :Customer:
<< this is straight forward>>