Create a Database for a security swipe key system

StudyAcer homework Experts at a Glance, Save Time and Excel

Writer avatar

Rating: 5/5    Reviews 482

Success rate 100%

Completed projects: 783

Hello, I am Prof Writers, I am a bold, accurate, and experienced tutor committed to providing clients with high quality, original, and timely work. As a writer, proficiency in several disciplines in academic writing is necessary, and that is why I prioritize on delivering quality and appropriate work. Be assured that I will always follow the lai...

Writer avatar

Rating: 4.9/5    Reviews 373

Success rate 97%

Completed projects: 592

Hello, I am a full-time professional freelance writer with over 6 years experience in academic writing. I have a PhD in Strategic Management and have done several projects in business management, marketing and other subjects. This experience has helped me reinforce my ability to work in various fields and handle simple and complex topics. I am a...

Writer avatar

Rating: 5/5    Reviews 1326

Success rate 96%

Completed projects: 1976

Hello :) My name is Dr.Success, I've started on my path as a professional writer mostly by writing essays. However, in the years since then, I've written various other academic papers, from research works to book reviews. From Sydney to New York, there are hundreds of students all over the world that are happy with the services I've provided the...

Writer avatar

Rating: 5/5    Reviews 371

Success rate 96%

Completed projects: 1173

Hi there! Im MarvellousTutor, your perfect author with huge writing experience in English, Art and Business. What? Need assignment on another subject? No worries: I can deal with anything! If you're dreaming of the reliable, responsible and always-on-time writer, here I am! I manage my time greatly, thus, your deadline is highly important for me...

Writer avatar

Rating: 4.7/5    Reviews 891

Success rate 96%

Completed projects: 1136

Hello there! My name is Prof Stephen. I have been a full-time freelance researcher and writer for a period of over 6 years. I have successfully completed over 1000 projects and assignments. I have had a good professional relationship with my clients who always come back for more quality papers since I highly value quality, professionalism, and i...

Writer avatar

Rating: 4.9/5    Reviews 244

Success rate 100%

Completed projects: 479

I'm ProfTzKelly, talented wordsmith, grammar afficionado, and writing machine. I'm written everything from outlines to screenplays and book reviews to advanced research papers. All you have to do to be well on your way to a great grade is chat with me! I'm experienced in all major styles, including APA, MLA, Chicago, Harvard, and Vancouver. You ...

Writer avatar

Rating: 5/5    Reviews 465

Success rate 96%

Completed projects: 852

Hey! My name is ProfAcer, and my goal is to help you to get through a tough period of your life. I've been a student, and I know that the amount of work some professors expect you to do can be unfair and overwhelming. And that's without even accounting for the job you probably have an active social life each student should have. There is no sham...

Writer avatar

Rating: 4.9/5    Reviews 412

Success rate 96%

Completed projects: 719

In academic writing, quality, originality, and deadlines are vital, and these are my primary offerings to all my clients. I have two years of experience as a full-time academic writer, with over 300 finance, economics, marketing, business, and general papers written from scratch. Since joining this site, I have also tackled sociology, healthcare...

Writer avatar

Rating: 4.8/5    Reviews 319

Success rate 98%

Completed projects: 584

Hello! People call me ThinkTank, and I've been earning money as an academic writer for years. With a lot of works under my belt, you can bet that I've dealt with dozens of various topics and different forms of papers, including essays, research papers, and even dissertations. I like the challenge that comes with this job. I first fell in love wi...

Create a Database for a security swipe key system

Do Not Copy. Order Custom, Original Paper.
Here is an overview of how key control works at Brock University: 


You are to design and implement the DB for this system. Read the web page and 
all the PDFs carefully to identify potential entities. Some attributes and entities may not be obvious (for example, there are levels of master keys which open more than one door). There also may be entities or attributes that do not appear on these forms but are essential to tracking keys (for example, what is the current status of a key request or lock change request?). You design must be able to answer the following questions through SQL queries:

  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 

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:

    1. A complete ER diagram of the final design. Please use a drawing tool to create this diagram (no hand-drawn diagrams!). There is an OpenOffice drawing program that will work nicely, and you may save the file in its native format. If you use another drawing tool (like Visio), please save the diagram as a JPEG. Or you can use Workbench and export as a JPEG, SVG or PDF. The name of the file should be both your myseneca IDs, separated by a hyphen (and don’t forget the correct file extension!). For example, jsmith-tjones.jpg
    2. dump of the schema fully implemented in MySQL as a SQL script – the dump should include everything necessary to recreate all the tables and views in btd210 (I will create the database) and load them with data. It should also recreate your users and grant them permission to the views as stated above. I will be loading this schema and testing it. The name of the file should be both your myseneca IDs, separated by a hyphen (and don’t forget the correct file extension!). For example, jsmith-tjones.sql. Note that this file requires the student honesty statement as a comment.

Need help with writing Create a Database for a security swipe key system?

Get help

  • StudyAcer

  • Trustpilot

  • Sitejabber


Please fill in the Order, to get Instant Homework Help

Attach files for the writers' reference