ScholarQuill logoScholarQuillUniversity Notes
My Semester
Explore Notes
Past Papers12 New
Video CoursesNew
Search
Settings
Study Tools
GPA/CGPA Calculator
Schedule & To-Do
Student Portal
Contact
Contact
ScholarQuill logo
My Semester
Explore Notes
Past Papers12 New
Video CoursesNew
Search
Settings
GPA/CGPA Calculator
Schedule & To-Do
Student Portal
Contact
ScholarQuill logoScholarQuillUniversity Notes
Study PortalITEC3128Database Protection
Ctrl + K
Login
Explore
Search
Semester
Papers
CGPA
    ITEC3128

    Information Technology Infrastructure

    Progress0 / 56 done
    Topics56
    1Definitions and Infrastructure management activities2Evolutions of Systems since 1960s (Mainframes-to-Midrange-to-PCs-to-Client-server computing-to-New age systems) and their Management3Growth of internet, current business demands and IT systems issues4Complexity of today's computing environment5Total cost of complexity issues6Value of Systems management for business7Factors to consider in designing IT organizations and IT infrastructure8Determining customer's Requirements9Identifying System Components to manage10Exist Processes, Data, applications, Tools and their integration11Patterns for IT systems management12Introduction to the design process for information systems
    13Complexity of current computing, multiple technologies, multiple vendors, multiple users14e-Waste disposal15Total cost of ownership
    16Common tasks in IT system management17Approaches for organization Management18Models in IT system design19IT management systems context diagram20Patterns for IT system Management21Information system costs and benefits22Capital budgeting for information system23Real Options pricing models24Limitation of financial models
    25IT services continuity management26Capacity management27Availability management and service desk
    28Service support process29Configuration Management30Incident management31Problem management32Change management33Release management
    34backups, Archive, Recovery, Disaster recovery35Space management36Hierarchical storage management37Network attached storage38Storage area network39Bare machine recovery40Data retention41Database protection
    42Introduction Security43Identity management44Single sign-on45Access Management46Basics of network security47LDAP fundamentals48Intrusion detection49Firewall50Security information management
    51Introduction to Cyber Ethics52Intellectual Property53Privacy and Law54Computer Forensics55Ethics and Internet56Cyber Crimes
    3 min read
    Topic 41 of 56
    Topic Study Note Illustration
    41

    Database protection

    Subject: Information Technology Infrastructure

    πŸ“˜ Topic: Database Protection

    Subject: Information Technology Infrastructure


    1. πŸ“Œ Introduction

    In modern IT systems, databases store critical organizational data such as customer records, financial transactions, employee details, and business reports. Because this data is highly valuable, it becomes a major target for unauthorized access, corruption, and cyberattacks.

    πŸ‘‰ To secure this, organizations implement Database Protection mechanisms.


    2. βœ… Definition

    Database Protection is the set of policies, tools, and security techniques used to safeguard a database from unauthorized access, misuse, corruption, loss, or destruction while ensuring data integrity, confidentiality, and availability.

    πŸ‘‰ Simple idea: It ensures β€œonly authorized users can access and safely use the database.”


    3. 🎯 Objectives of Database Protection

    • Ensure data confidentiality (no unauthorized access)
    • Maintain data integrity (no unauthorized changes)
    • Ensure availability of data when needed
    • Prevent data loss or corruption
    • Protect against cyberattacks and misuse

    4. 🧩 Key Threats to Databases

    • Unauthorized access πŸ”“
    • SQL injection attacks πŸ’‰
    • Malware and ransomware 🦠
    • Human errors πŸ‘€
    • Hardware failure πŸ’½
    • Insider threats (employees misuse data)

    5. βš™οΈ Methods of Database Protection


    πŸ”‘ 1. Authentication

    • Verifies user identity

    πŸ“Š Example:

    • Username and password
    • Biometric login (fingerprint)

    πŸ”‘ 2. Authorization

    • Controls what users can access

    πŸ“Š Example:

    • Admin can edit data
    • User can only view data

    πŸ”‘ 3. Encryption

    • Converts data into unreadable format

    πŸ“Š Example:

    • Password stored as encrypted hash

    πŸ”‘ 4. Backup and Recovery

    • Copies data for restoration

    πŸ“Š Example:

    • Daily database backup

    πŸ”‘ 5. Access Control

    • Restricts database access using roles

    πŸ“Š Example:

    • Read-only access for interns

    πŸ”‘ 6. Auditing and Logging

    • Tracks user activities in database

    πŸ“Š Example:

    • Recording who accessed customer data

    πŸ”‘ 7. Firewalls and Network Security

    • Blocks unauthorized network access

    6. πŸ“Š Diagram Description

    Users β†’ Authentication β†’ Authorization β†’ Database Access β†’ Logging & Monitoring
    

    7. 🧠 Real-Life Example

    In a banking system:

    • Customers log in using secure credentials
    • Only authorized staff can modify account data
    • All transactions are encrypted
    • Backup systems store data daily
    • All actions are logged for audits

    πŸ‘‰ Result:

    • High security
    • No unauthorized access
    • Safe financial data

    8. βš™οΈ Importance of Database Protection

    • Protects sensitive business data
    • Prevents financial losses
    • Ensures compliance with laws (e.g., GDPR-like rules)
    • Maintains customer trust
    • Supports business continuity

    9. ⚠️ Challenges

    • Increasing cyberattacks
    • Complex database systems
    • Managing user permissions
    • Performance impact of security tools
    • Human errors and insider threats

    10. πŸ”„ Database Protection vs Data Security

    Feature Database Protection Data Security
    Scope Focus on databases Covers all data systems
    Tools DBMS security tools Firewalls, antivirus, etc.
    Focus Structured data All types of data

    11. πŸ“ Likely Exam Questions

    ⭐ Short Questions:

    1. Define database protection.
    2. What is authentication?
    3. What is encryption?
    4. What is access control?
    5. What is database auditing?

    ⭐ Long Questions:

    1. Explain methods of database protection.
    2. Discuss importance of database security in IT systems.
    3. Describe authentication and authorization with examples.
    4. Explain threats to database systems.
    5. Draw and explain database protection process.

    12. πŸ“Œ Quick Summary / Conclusion

    • Database protection ensures security, integrity, and availability of stored data.

    • It uses:

      • βœ” Authentication
      • βœ” Authorization
      • βœ” Encryption
      • βœ” Backup & recovery
      • βœ” Access control and auditing

    πŸ‘‰ Final Idea: Strong database protection is essential for secure, reliable, and trustworthy IT systems in modern organizations.


    βœ… Exam Tip: Always include:

    • Definition
    • Security methods (at least 5–6 points)
    • Diagram
    • Real-life example (very important for marks)
    ← Previous topic 40
    Data retention
    Next topic 42 β†’
    Security Management: Introduction Security

    Past Papers

    Open this section to view and download past papers

    Click on Show Past Papers to load available exam papers.

    Reading Progress
    0%
    3mremaining
    554words
    Beginnerlevel
    On This Page

    No headings found

    Study Toolkit

    Subject Portal

    Information Technology Infrastructure