I am not a database programmer, but do the best I can.
I want to build a database which allows for the reservation of computer equipment, but with a difference.
I keep a number of laptops and tablets on hand that are checked out for researchers/data gatherers to use at remote locations. Project managers simply ask for a certain number of each type of device to be reserved for particular periods of time, which could be anything from a day to several weeks.
I would like a database that could make this kind of reservation, with the ability to show the quantity of devices available on any given date. Tracking of individual devices is not necessary. Only quantities of device types are important.
I haven't a clue how to design this. Typically I use a spreadsheet to track assets, but this is a bit different. Where should I start?
I want to build a database which allows for the reservation of computer equipment, but with a difference.
I keep a number of laptops and tablets on hand that are checked out for researchers/data gatherers to use at remote locations. Project managers simply ask for a certain number of each type of device to be reserved for particular periods of time, which could be anything from a day to several weeks.
I would like a database that could make this kind of reservation, with the ability to show the quantity of devices available on any given date. Tracking of individual devices is not necessary. Only quantities of device types are important.
I haven't a clue how to design this. Typically I use a spreadsheet to track assets, but this is a bit different. Where should I start?