Forgive if the answer to this is obvious, but I have no clue what keywords to google with.
I'm designing a database for a school that has a variety of IT resources it can lend out (such as iPads, laptops, projectors)
My database keeps track of the resources by using a booking log. The problem I have is the resources can be booked by either a student, teacher, or a school associate member.
This is my design.
Student, staff and associate members each have their own table, and their own attributes.
How do I design the tables and relationships so the resource hire log keeps track of who's booked the resource?