What is the best/efficient DB Design for a device reservation system? RRS feed

  • Question

  • Hi,

    I have to design table structure for a device reservation system. The user can reserve any device for a period of time (start time and end time). 

    Based on the reserved devices

    1) I need to show on the UI if the device is reserved or available

    2) for any logged in user, to reserve, how do I validate and check all the devices and allow the user to reserve the device with minimal logic

    Each reservation for a particular time for a device may be present as one record, when the user is reserving we have to consider the entire set of records to arrive at a conclusion whether the device is reserved or free for that particular amount of time. How do we do this with minimal logic and what is best db/table design for this kind of system.

    Monday, March 30, 2015 12:25 PM