Creat SQL script to run queries to an existing DATABASE

profileclasic1

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

 

  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.
    • 8 years ago
    • 50
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      keymgmtqueries.sql
    • attachment
      keymgmt.sql
    Bids(1)