Reference no: EM132186988
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? Examples are provided here to help 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.
|
Discuss the key problems facing an organization
: Discuss the key problems facing an Organization as it changes from an entrepreneurship to a professionally managed company in stage 3.
|
|
Explain how you will overcome threats from each of the five
: Explain how you will overcome threats from each of the five forces while achieving your professional goal(s) after graduation from the MS-IST Program.
|
|
Agile project management-critical chain project management
: Compare and contrast agile project management (agile PM) and critical chain project management (CCPM) scheduling,
|
|
How would you decide which one should be addressed first
: Propose a scenario where two specific maintenance requests are competing for the attention of the system administrators and technical support staff.
|
|
Create a database administration plan
: What is your rationale for the transaction management plan, database security procedure, backup plan, and recovery model that you proposed for the case study
|
|
Describe what is e-commerce and mobile technology
: Your manager thinks they may be able to turn the company around if they can get help from an IT professional on E-Commerce and Mobile Technologies.
|
|
Investigate and defend the two cost leadership
: Investigate and defend the two cost leadership approaches based on organizational structures.
|
|
Provide a convenient self-service solution for customers
: CIS 375: The Web application would need to be available on mobile devices (e.g., smartphones, tablets, laptops, notebooks).
|
|
Compare English with Arabic in terms of vocabulary
: Write 4-5 pages (1500 words) on given topic. Topic - Compare English with Arabic in terms of vocabulary, cultural, language use
|