Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    HSAGHSH

    Uploaded by

    s.snjbarsubia

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    HSAGHSH

    Uploaded by

    s.snjbarsubia
    4 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    4 views3 pages

    HSAGHSH

    Uploaded by

    s.snjbarsubia

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    ### Enumerations:

    1. **Intended Learning Outcomes:**


    - Differentiate data and information
    - Define database and database systems
    - State the role and advantages of the DBMS
    - Explain the evolution of File System Data Processing
    - Describe the problems with File System Data Processing

    2. **Advantages of a Database Management System (DBMS):**


    - Improved data sharing
    - Improved data security
    - Better data integration
    - Minimized data inconsistency
    - Improved data access
    - Improved decision making
    - Increased end-user productivity

    3. **Types of Databases:**
    - Single-user database
    - Multiuser database
    - Centralized database
    - Distributed database
    - Operational database (Transactional or production database)
    - Data warehouse
    - Unstructured data
    - Structured data
    - Semistructured data
    4. **Major Parts of a Database System:**
    - Hardware
    - Software
    - People
    - Procedures
    - Data

    5. **DBMS Functions:**
    - Data dictionary management
    - Data storage management
    - Data transformation and presentation
    - Security management
    - Multiuser access control
    - Backup and recovery management
    - Data integrity management
    - Database access languages and application programming interfaces
    - Database communication interfaces

    6. **Problems with File System Data Processing:**


    - Extensive programming required
    - Ad hoc queries impossible
    - Changing existing structure difficult
    - Structural and data dependence
    - Data redundancy
    - Data inconsistency
    - Data anomalies (Update, Insertion, Deletion anomalies)
    7. **Disadvantages of Database Systems:**
    - Increased costs
    - Management complexity
    - Maintaining currency
    - Vendor dependence
    - Frequent upgrade/replacement cycles

    ### Key Concepts:


    - **Data vs. Information:** Data are raw facts, while information is
    processed data that reveals meaning.
    - **DBMS:** A collection of programs that manage the database structure
    and control access to data.
    - **File System Data Processing Evolution:** Understanding the
    transition from manual systems to computerized file systems and then to
    modern databases.
    - **Data Redundancy and Inconsistency:** Issues that arise when the
    same data is stored in multiple locations, leading to conflicts and
    anomalies.

    You might also like