Entities and Attributes of Disaster Recovery and Business Continuity Planning
1. Business Process: Represents the essential operational functions of an organization.
- PROCESS_ID(Primary key) : It is a unique Identifier for each business process.
- PROCESS_NAME : It describes name of the Business process.
- PRIORITY_LEVEL : It describes Priority level of the Business process.
2.Resource : Encompasses the various assets, information and facilities essential for the operation of business processes.
- RESOURCE_ID(Primary key) : It is a unique Identifier for each resource.
- RESOURCE_TYPE : It specifies type of the Resource.
- RESOURCE_NAME : It describes name of the Resource.
3.Recovery Site : Refers to an alternate location where the organization can resume operations following a disaster.
- SITE_ID(Primary key) : It is a unique identifier for each Site.
- SITE_NAME : It Describes the name of the Site.
- LOCATION : It Describes the physical location of Site.
4.Data backup : Represents copies of important data stored separately.
- DATA_ID(Primary key) : It is a unique identifier for each data backup.
- TYPE : It describes the type of the backup.
- LOCATION : It specifies the location of the backup.
5.Incident : Represents an event hat significantly disrupt.
- INCIDENT_ID(Primary key) : It is a unique identifier for each Incident.
- TYPE : It describes the type of the incident.
- IMPACT_LEVEL : It indicates the impact level of the Incident.
- DATE : It provides the date of the incident.
6.Plan : Denotes a documented strategy.
- PLAN_ID(Primary key) : It is a unique identifier for each plan.
- PLAN_TYPE : It specifies the type of the plan.
- DESCRIPTION : It provides description of the plan.
How to Design ER Diagrams for Disaster Recovery and Business Continuity Planning
In the fast–paced world of business, being prepared for the unexpected is key to success. Disaster Recovery (DR) and Business Continuity Planning (BCP) are important for ensuring that a business can quickly bounce back from disruptions. To create effective DR and BCP strategies, we need a solid understanding of our organization’s assets, risks, and recovery processes. At the core of this planning is the design of a strong database system. In this article, we’ll walk through how to create Entity-Relationship (ER) diagrams with the help of entities and attributes and relationships between them.