Overview All businesses today use some form of a database to store their important data. Whether it is used to store client information, product inventories, sales activity or even information about their employees, a database is integral to the operation of a business. We have spent the semester learning about databases: how they work and how to effectively design and create them. We have built our databases and have inserted data, updated, deleted and queried the data. Since a database plays a major role for businesses today, it is not surprising that keeping that data safe is major responsibility and priority. We witness almost daily, data breaches that occur with our sensitive information due to shortcomings in database security. The aim of this project is to identify those security issues and what can be done to prevent breaches. Details Assume you work in the IT department for an organization that uses a database to store all their sales and customer information. Choose one of the topics below and write a report that describes the security issues, ramifications of poor design, and identifies best practices
Malicious SQL statements – Encrypting databases – Physical database security – Database administration: roles and privileges IF WORKING WITH A PARTNER: In addition to the above, include a recent example from the news and suggestions on how the attack/breach could have been prevented. You may choose one of the following formats for your report: – You are writing a blog post for the IT employees of your company that will be posted internally on the company website. – You are preparing a memo to the top management of the company on the topic. – You are creating a powerpoint (or similar) presentation on the topic to present to top management. Include extensive notes to accompany the slides. (approx. 12 slides) – You are writing a newsletter article on the topic that goes out to all the IT employees in the company. – Regardless of which format you choose, adjust your writing to the intended audience. Requirements – Include a title page for your report with your name(s) – The report will be double-spaced and have 12 point font (Times New Roman or Calibri). You should aim to have about 1000 words (approx. 3 pages double spaced) – A minimum of two sources must be used. – The report must be accompanied by a “Works Cited” page. Use CSE-CBE formatting for your sourcing. – Submit your word file to the Project submissions folder by 11:59 pm, December 13th – If you are working with a partner, only one person needs to submit.