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