A SQL script that contains the queries for the
25 questions.
- List all people who have keys.
- List all people who have keys to a particular room.
- List all people who have keys to a particular building.
- List all people who have keys to a particular door (lockset).
- List all people who have master or submaster keys.
- List all people who have a particular master or submaster key.
- List all keys and the doors they open.
- List all unique keys types (Corbin, Yale, etc).
- List all unique categories of keys.
- List all keys for a particular door (lockset).
- List all keys for a particular room (a room can have multiple doors and a door can have multiple keys).
- List all keys for a particular building.
- List all keys a person has, along with their building, room and door.
- List all lost keys.
- List all master keys.
- List all submaster keys.
- List all locksets a master key works on.
- List all key requests still pending.
- List status of a particular key request.
- List all keys requests made between two dates.
- List all keys issued between two dates.
- List all lock repair requests still pending.
- List all lock repair requests made between two dates.
- List all lock repair request finished between two dates.
- List that status of a particular repair request.