Read the Scenario:
Local Shows and Acts Patti and Dennis like to follow local bands. They often miss concerts because they only hear about them after the event. Typically, the only advertisement of an upcoming performance for some of these artists is a paper bill tacked to a street lamp or pasted on the side of a building. Sometimes there will be ads in the free community papers, but there is no one place to locate the information. Many of their friends share similar frustrations. It is impossible to have a clear idea of who is playing where at any given time. Patti and Dennis came up with the idea of a database that would store all of the information about artists and shows in one place. Ultimately they would build a Web page based on the database that everyone could access and use. They started by pedaling their idea to some of the more popular venues. The venues expressed interest. For the most part, they liked the idea of a central place where people could get a complete picture of the current music scene. It could result in more customers. Some even inquired about advertising opportunities. Patti and Dennis also talked to some artists they knew. The artists also thought it was a good idea. They knew the hand bills were not very effective, though some of them liked the artistic effort of designing them. Another idea they had was that fans could register and select which artists or genres of music they liked and be informed of upcoming shows. Encouraged by the response, Patti and Dennis are looking for someone to help design the database.
A. Standards: Articulate the relevant legal and ethical standards that need to be considered in your solution design and in future implementation.
B. Legal Compliance: Determine the best practices in design, data use, and storage to ensure legal compliance. The regulations in place and the best practices for aligning operations will likely change depending on the type of industry in which your company resides. Support your conclusions with research support.
C. Ethical Practices: Determine best practices in design, data use, and storage to ensure the ethical operation of your company. These best practices will likely change depending on the industry in which your company resides. Support your conclusions with research support.
D. Security Needs of Solution: In consideration of the type of organization you selected, the data used, and your consideration of legal and ethical standards, discuss the security needs of your DBMS solution. Considering the group/department for which you constructed your enterprise data model, discuss the differences in security needs at this level in comparison with those of the company as a whole.
E. Database Security Plan: Given the comparisons and discussions above, recommend a comprehensive but high-level (pertaining to the solution as a whole rather than the particular department) security management plan for your design that will align to organizational needs.