Create a Database for a security swipe key system

1. List all people who have keys.
2. List all people who have keys to a particular room.
3. List all people who have keys to a particular building.
4. List all people who have keys to a particular door (lockset).
5. List all people who have master or submaster keys.
6. List all people who have a particular master or submaster key.
7. List all keys and the doors they open.
8. List all types of keys.
9. List all categories of keys.
10. List all keys for a particular door (lockset).
11. List all keys for a particular room (a room can have multiple doors and a door can have multiple keys).
12. List all keys for a particular building.
13. List all keys a person has, along with their building, room and door.
14. List all lost keys.
15. List all master keys.
16. List all submaster keys.
17. List all locksets a master key works on.
18. List all key requests still pending.
19. List status of a particular key request.
20. List all keys requests made between two dates.
21. List all keys issued between two dates.
22. List all lock repair requests still pending.
23. List all lock repair requests made between two dates.
24. List all lock repair request finished between two dates.
25. List that status of a particular repair request.

Implement this DB under your 
btd210 DB.

Create a view named securityDesk for security personnelso they can do the following things (and only the following things!):

• take a key request
• issue a key
• change the status of a key
• take a lock repair request
• close a lock repair request
• change the status of a lock
• make any of the above queries (and other similar queries)

Create a view named keyManager for the person who manages the key control system so he can do the following things (and only the following things):

• everything the securityDesk can do
• add new keys
• add new locksets
• add new buildings
• add new rooms

Create the following MySQL users:

• a security desk employee named secdesk
• a key manager named keyman
• a DB administrator named admin. 

For all three make the password 
btd210

You should also apply appropriate security to the DB – grant these users appropriate permission (for the first two, it would be on their associated views, and for the admin it should be all permission for everything in the DB).

If you have any questions about how this key control system works, ask me for clarification.

The final project should include the following: