CIS 515 Week 10 Technical Paper Database Administrator For Department CIS 515 Week 10 Technical Paper Database Administr | Page 3

6. Evaluate whether the use of a distributed DBMS structure is appropriate and identify the
optimization techniques that should be factored in to enhance the operations of the database
in your design.
7. Provide at least two (2) examples of how lost updates and uncommitted data may occur,
keeping in mind that five (5) stores will be generating transactions.
8. Determine the concurrency control factors that can be used to ensure valid execution of
transactions within the current multiuser environment.
9. Research the Internet for backup and restoration recovery solutions and database security
threats that could be applicable to the department store. Upon your research, complete the
following:
a. Suggest at least two (2) options that could be made available to provide disaster
management functions for the database system within the retail environment.
b. Assess the types of security threats that may exist when managing the department store
database and suggest measure(s) that can be performed to minimize these threats that are
particular to retail.
10. Use at least six (6) quality resources in this assignment. Note: Wikipedia and similar
Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all
sides; citations and references must follow APA or school-specific format. Check with your
professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the
professor’s name, the course title, and the date. The cover page and the reference page are not
included in the required assignment page length.
• Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such
as Open Project, Dia, and Open Office. The completed diagrams / charts must be imported into
the Word document before the paper is submitted