In studio today we went through our database schema with Matt, and he pointed out an area where we could improve our design. We had been allocating specific equipment items to loans when students placed a booking. This added unnecessary complications to the loan process because it meant we had to check if a specific item was available for the duration of the booking, rather than just checking if any suitable item was available on each day.
Matt suggested that we link a piece of equipment to a loan when the student collects it instead. That will also make it easier for Mark and Shelley to process collections, because they will be able to pick up any suitable item off the shelf, instead of having to look for specific items (i.e. DV Camera #564).
Fixing this problem in the database meant simply adding a relationship between the loan and product tables.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment