hi everyone well basically i am creating a laptop booking system
I have a teachers table with relevant teacher information including first name, surname and teacher ID
I have a laptop trolley table consisting of trolley number, number of laptops and base location
i have a laptop table which consists of trolley number, laptop number, operating system and memory
my final table is a booking table which contains teacher ID, booking ID, trolley number, period (only have 5 periods) , date, room and date.
I want to create a query which shows us lessons that the laptops havent been booked for on a certain date.
thank you very much