Description
Key Assignment Draft
The case study retail store is concerned about the possibilities of losing data because of database system malfunctions or downtime. Security is also a major concern to the company because it is common knowledge that engaging in online business can be risky because of known vulnerabilities on the Internet. The company also realizes that its in-store database system is the top priority at this time. What solutions can you propose to effectively manage database transactions, maintain security, and recover the data that are lost from system failure or downtime?
Review these examples to help you with this assignment.
The assumptions are as follows:
A high volume of the orders often occurs during the daytime.
One person will serve the role of database administrator.
The database administrator account will serve as database owner.
The transaction log must be backed up.
Point-in-time recovery is required.
There is an always-on availability group.
The ability to purchase products online will be addressed in a future database project.
The project deliverables are as follows:
What solutions can you propose to effectively manage database transactions, maintain security, and recover the data that are lost from system failure or downtime?
What is your rationale for the transaction management plan, database security procedure, backup plan, and recovery model that you proposed for the case study organization?
Database Administration Plan (4–5 pages)
Create a database administration plan that is specific to the needs of your retail store.
Include a transaction management plan that includes a flowchart for how each transaction will be handled (including rollback and commit cases).
Include a database security procedure that includes provisions for access control, user authentication, and availability.
Include a backup plan and a recovery model
Provide your analysis as to how this part of the project fulfills the mission and 1 or more goals of the case study organization.
All sources should be cited both in-text and in References using APA format.
Name the document “yourname_CS660_IP4.doc.”
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more