...
- CRUD a key
- CRUD room information
- CRUD key holder information
- CRUD department information
- assign keys
- transfer keys from one holder to another
- keyoholder returns key
- keyholder loses key
- show key inventory
- show rooms and keys brief list
- show key inventory
- show key holders and their keys
- show keys assigned to key holders
- keyoholder returns key
- keyholder loses key
- show reports
We need more information about reports. The user guide names nine reports, but doesn't give a detailed description of what they show. We may be able to copy the SQL from the existing system.
...