Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

CST2355 – Database Systems: Assignment 1 CST8276 - Advanced Database Topics Assignment 4: Designing Business Continuity Procedures (10%) This assignment relates to the following Course Learning...

1 answer below »
CST2355 – Database Systems: Assignment 1
CST8276 - Advanced Database Topics
Assignment 4: Designing Business Continuity Procedures (10%)
This assignment relates to the following Course Learning Requirements:
CLR 2 - Administer a DBMS using knowledge of SQL, database security features, globalization and database architecture (storage, memory and processes)
Objectives of the Assignment
You are asked by management to prepare a database proposal which will cover three critical components: Backup Strategy, Disaster Plan, and Business Continuity Plan.
Business Scenario
Please read the business requirement/scenario below.
    The company has four Oracle databases. They're located in Toronto, Vancouver, Winnipeg, and Calgary.
As a policy, each location has a local backup that only backs up the data for that day and every hour of that day. Every 7 days each location makes a full backup of their database and sends it to a remote location for archival.
When a database needs to be restored because of disruption, one location that was not affected by the disruption, creates, runs, and maintains that database until the disrupted location is up and running.
A winter storm hits Winnipeg resulting in them losing all the data in their database. All that they have is the incremental backups from the last 3 days.
Instructions
Analyze the business scenario provided above.
Create a report (separate WORD document) include the following three sections. You will need to do some ‘googling’ to find ideas but as the company’s DBA, you need to prepare this set of proposals for management. Modules 9, 10 and 11 discuss this subject as well.
Backup strategy – how should the company’s data be backed up to prevent / minimize data loss (include such ideas as offsite storage, etc.
Disaster Planning -- list your ideas on how to quickly and effectively restore database operations in the event of a ‘disaster’ such as the scenario above
Business Continuity Plan -- explain your ideas for a new Business Continuity Plan and if relevant, what roles (who) should be responsible for some of the steps. What planning, activities, communications, and assessments should be done to prepare for a disaster and to ca
y out during a disaster?
Submission Requirements
To submit this assignment, submit your file as a WORD document using the assignment upload tool in Brightspace.
Please note: Algonquin College has a policy regarding Plagiarism. The consequences are immediate zeroes for assignments and potentially an instant fail for the whole course. It is only natural for students to work together to complete assignments.
DO NOT PLAGIARIZE each other’s wo
Table 1 - Assignment 4 Grading Ru
ic
    
    Exemplary
    Accomplished
    Developing
    Incomplete
    Criteria
    3
    2
    1
    0
    Backup Strategy
    Majority of steps are included. Each step is clearly titled and explained.
    Included at least 75% of steps that are titled and explained.
    At least 50% of steps are included.
    Not completed
    Disaster Planning
    Majority of steps are included. Each step is clearly titled and explained.
    Included at least 75% of steps that are titled and explained.
    At least 50% of steps are included.
    Not completed
    Business Continuity Plan
    Majority of steps are included. Each step is clearly titled and explained.
    Included at least 75% of steps that are titled and explained.
    At least 50% of steps are included.
    Not completed
End of Assignment
1
Answered 6 days After Mar 12, 2023

Solution

Amar Kumar answered on Mar 18 2023
30 Votes
Business Scenario Analysis:
The scenario describes a company with multiple Oracle databases located in different cities. The company follows a backup policy where each location has a local backup that backs up data for the day and every hour of that day. Every 7 days, each location makes a full backup of their database and sends it to a remote location for archival. When a database is disrupted, another location that was not affected by the disruption creates, runs, and maintains that database until the disrupted location is up and running. In the case of a winter storm hitting Winnipeg and losing all the data in their database, the company only has incremental backups from the last three days.
Overall, the company's backup strategy and disaster planning appear to be inadequate, as they have only been able to recover data from the last three days. The business continuity plan also seems to be missing or inadequate, as there is no clear plan for quickly and effectively restoring database operations in the event of a disaster.
Proposed Backup Strategy:
To prevent or minimize data loss, the company should implement a more comprehensive backup strategy that includes the following:
a. Daily Backups: Instead of hourly backups, the company should consider taking a daily backup of the database. This will ensure that even if a disruption occurs, the company will only lose a day's worth of data.
. Offsite Storage: The company should store backup data offsite to ensure that it is not affected by any disruptions at the primary location. The offsite storage should be in a different location than the remote location used for archival purposes.
c. Incremental Backups: The company should consider taking incremental backups more frequently, for example, every 30 minutes or every hour. This will ensure that the company has more recent data to recover in case of a...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here