¾}sS< eU/ Institution Name ¾Ê¡S”ƒ lØ`/ Document No.
KPC/OBT/EX/003
ኮምቦልቻ ፖሊቴክኒክ ኮሌጅ
KOMBOLCHA POLYTECHNIC COLLEGE
ርዕስ/ Title Issue No. Page No.
Learning Guide 1 Page 1 of 4
Effective Date: 14/04/2017
Slide 1: Title Slide
Title: Database File System Architecture, Risks, and Occupational Health & Safety
(OHS)
Subtitle: Understanding DBMS Tiers, Failure Scenarios, and OHS in Backup &
Recovery
Slide 2: Definition 1 - Database Architecture
Definition: Database architecture refers to the design, development, implementation, and
management of a database system's structure to store, retrieve, and manage data
efficiently.
Slide 3: Definition 2 - DBMS (Database Management System)
Definition: DBMS is a software system that enables users to define, create, maintain, and
control access to a database.
Slide 4: Definition 3 - Occupational Health and Safety (OHS)
Definition: OHS refers to policies and procedures aimed at ensuring the safety, health,
and welfare of employees at work, especially when handling technological systems like
databases.
Slide 5: Single-Tier Architecture
Definition: All components (client, server, and database) exist on the same machine.
Example 1: A standalone SQL practice setup on a local machine.
Characteristics: Direct access, rarely used in production.
Slide 6: Two-Tier Architecture
Definition: Client and server exist on separate machines. Clients access the DBMS using
APIs like ODBC/JDBC.
Example 2: A desktop application querying a central server-hosted database.
Benefits: Enhanced security, query processing on server.
Striving for Excellence, Elevating Quality.
¾}sS< eU/ Institution Name ¾Ê¡S”ƒ lØ`/ Document No.
KPC/OBT/EX/003
ኮምቦልቻ ፖሊቴክኒክ ኮሌጅ
KOMBOLCHA POLYTECHNIC COLLEGE
ርዕስ/ Title Issue No. Page No.
Learning Guide 1 Page 2 of 4
Effective Date: 14/04/2017
Slide 7: Three-Tier Architecture
Definition: Separates database, application (logic), and presentation layers.
Features: Scalability, program-data independence, multiple views.
Used in: Web and distributed applications.
Slide 8: N-Tier Architecture
Explanation: Extension of 3-tier, further division for large applications.
Includes: Logic, presentation, and data tiers.
Slide 9: Common Database Failure Causes (Intro)
Topic: Risks and Failure Scenarios
Databases are vulnerable to various threats that may lead to data loss.
Slide 10: Power Failure
Impact: Hardware issues, data inaccessibility or loss.
Prevention: Use UPS, regular backups.
Slide 11: Disk Failure
Impact: Data corruption from head crashes or unreadable media.
Mitigation: Use RAID systems, regular disk health checks.
Slide 12: Human Error
Examples: Accidental deletion or modification.
Note: Most common cause of data loss.
Striving for Excellence, Elevating Quality.
¾}sS< eU/ Institution Name ¾Ê¡S”ƒ lØ`/ Document No.
KPC/OBT/EX/003
ኮምቦልቻ ፖሊቴክኒክ ኮሌጅ
KOMBOLCHA POLYTECHNIC COLLEGE
ርዕስ/ Title Issue No. Page No.
Learning Guide 1 Page 3 of 4
Effective Date: 14/04/2017
Slide 13: Software Corruption
Causes: Application crashes, OS failure.
Effects: Data loss, transaction failure.
Slide 14: Virus Infection & Natural Disasters
Virus Effects: Data theft, corruption, deletion.
Disasters: Fire, flood, earthquakes can destroy infrastructure.
Slide 15: Disgruntled Employees & Hardware Failure
Risks: Sabotage, unauthorized data access.
Failures: Bad sectors, memory errors, disk full.
Slide 16: System & Network Crashes
System Crashes: Hardware/software errors lead to processing halt.
Network Failure: Breaks connection in distributed systems.
Slide 17: Sabotage
Definition: Intentional destruction or data corruption.
Example: Injecting malware into the DBMS.
Slide 18: OHS Guidelines for DB Backup & Recovery (Intro)
Purpose: Protect staff involved in managing database systems.
Slide 19: Training and Ergonomics
Train staff on backup & recovery.
Ensure ergonomic workplaces to reduce physical strain.
Slide 20: Workload & Emergency Preparedness
Striving for Excellence, Elevating Quality.
¾}sS< eU/ Institution Name ¾Ê¡S”ƒ lØ`/ Document No.
KPC/OBT/EX/003
ኮምቦልቻ ፖሊቴክኒክ ኮሌጅ
KOMBOLCHA POLYTECHNIC COLLEGE
ርዕስ/ Title Issue No. Page No.
Learning Guide 1 Page 4 of 4
Effective Date: 14/04/2017
Avoid burnout through workload balancing.
Set up evacuation & emergency protocols.
Slide 21: Security, Equipment, and Health Monitoring
Protect against cybersecurity threats.
Maintain hardware/tools.
Encourage regular health check-ups.
Slide 22: Documentation and Communication
Maintain clear procedures.
Foster open communication about OHS concerns.
Slide 23: Regulatory Compliance
Stay updated with local and national OHS standards.
Regular audits and reviews.
Slide 24: Summary & Conclusion
Understanding architecture is key to secure DBMS.
Risks must be mitigated.
OHS is essential for sustainability and safety.
Striving for Excellence, Elevating Quality.
