Unit:Techniques Used in Database Administration 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 riskybecause 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 arelost from system failure or downtime? Examples are provided to help with this assignment (PLEASE SEE ATTACHED FILE/Understanding DatabaseTransactions. 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 arelost 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 ormoregoals of the case study organization. February 25, 2022 Read More »
Students are required to write case studies to discuss the role of enterprise systems and the use of digital transformation in their operations. February 18, 2022 Read More »
Was cloud computing the right option for ATN considering their services and products? Why or why not? February 18, 2022 Read More »
Describe the problems that MetLife was experiencing with customer data before it implemented the MetLife Wall. February 18, 2022 Read More »
Imagine you are the director of College XYZ and you have the vision to create a technology-first campus where latest technology is utilized in all spheres of administration as well as teaching. February 18, 2022 Read More »
Bill’s business is already expanding. He thinks that in a few weeks he will need to hire one or two employees to help him. He knows that each new employee will need their own computer February 18, 2022 Read More »