Creat SQL script to run queries to an existing DATABASE

A SQL script that contains the queries for the 
25 questions. 

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

 

  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 unique keys types (Corbin, Yale, etc).
  9. List all unique 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.

Order a unique copy of this paper

600 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal

Order your essay today and save 25% with the discount code GREEN