I plan on building a web based room booking application for meeting rooms at a company. The requirements are not set in stone and are pretty much left to me, as long as these core ones are met:
- Users can view monthly schedule for meeting room, so see what days and times there are bookings for a particular room.
- Users can book a meeting room
- Users can edit,delete a booking once made.
- Receptionists have power to cancel bookings, even though they were not the ones that made them.
If I have missed any obvious ones, please point them out.
So with the above in mind, I have come up with the following ERD.
Can you see any obvious issues with the above ERD? I have gone through the above scenarios / requirements, and I believe the above design satisfies them all, but it is possible that I am very much mistaken (has happened before).
Any help and feedback would be greatly appreciated.