Electronic Equipment Bookings System

[Marshall]

I am currently in the middle of designing a simple system to enable
technicians and students to book specific equipment at certain times for use.

The basic table plans are easy it is simply being able to set them so that
it is not possible to log a booking if it overlaps with another booking. The
bookings must be possible down to the 1/4 hour.

When selecting the equipment to book, i also would like it to not be able to
display any equipment not available over the period selected.

Any ideas would be gratefully recieved

Many Thanks

 

[Designing-Systems.com]

hi,

you will create three tables
1. Students and Technicians
2. Equipment
3. Equipment Booking

Equipment booking will link booked equipment and people and the times of the
booking.

For each new booking query the table to view of the equipment is already
booked for the specified time. Allow booking only if equipment is available
in the specified time.

Regards,