Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Database System

    Uploaded by

    Naivedyam Vineeta Mishra

    Copyright:

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

    Database System

    Uploaded by

    Naivedyam Vineeta Mishra
    3 views12 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    3 views12 pages

    Database System

    Uploaded by

    Naivedyam Vineeta Mishra

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 12

    Database System

    ADP CS
    Database system:
    • Database Management Systems (DBMS) are software systems used to
    store, retrieve, and run queries on data.
    • A database management system is a software to store, organize, manage,
    and retrieve data.
    • A DBMS serves as an interface between an end-user and a database,
    allowing users to create, read, update, and delete data in the database.
    • DBMS manage the data and helps provide data security, data integrity,
    concurrency, and uniform data administration procedures.
    Data security, data integrity, concurrency

    • Data security is the process of safeguarding digital


    information throughout its entire life cycle to protect it from
    corruption, theft, or unauthorized access.
    • It covers everything—hardware, software, storage
    devices, and user devices; access and administrative
    controls; and organizations' policies and procedures.
    Data integrity

    • Data integrity is the maintenance of, and the assurance


    of, data accuracy and consistency over its entire life-
    cycle.
    • It is a critical aspect to the design, implementation, and
    usage of any system that stores, processes, or retrieves
    data.
    Data concurrency

    • Data concurrency is the ability to allow multiple users to


    affect multiple transaction within a database.
    • Simply, data concurrency allows multiple users to access
    data all at the same time.
    Database system:
    • This helps provide data security, data integrity, concurrency, and
    uniform data administration procedures.
    • DBMS optimizes the organization of data by following a database
    schema design technique called normalization, which splits a large
    table into smaller tables when any of its attributes have redundancy
    in values.
    • Database management systems can be classified based on a
    variety of criteria such as the data model, the database distribution,
    or user numbers. The most widely used types of DBMS software are
    relational, distributed, hierarchical, object-oriented, and network.
    What are the 5 major parts of a database system?

    • The five major components of a database are hardware,


    software, data, procedure, and database access
    language.
    What are the four 4 elements of database?
    • The basic structures of a relational database (as defined by the
    relational model) are fields, records, table and database.

    • Fields: Within a database, a field contains the most detailed


    information about events, people, objects, and transactions.
    • Record: A record is a collection of related fields.
    • Table: A table is a collection of related records with a unique table
    name
    • Database: A database is a collection of related tables.
    What type of information is stored in a database?
    • Databases are used in most modern applications, whether the
    database is on your personal phone, computer, or the internet.
    • An operational database system will store much of the data an
    application needs to function, keeping the data organized and
    allowing users to access the data.
    • If you were building an eCommerce app, some of the data you
    might access and store in your operational database system
    includes:
    What type of information is stored in a database?

    • Customer data, like usernames, email addresses, and


    preferences.

    • Business data, like product colors, prices, and ratings.

    • Relationship data, like the locations of stores with a


    specific product in stock.
    Database benefits

    • Minimum data redundancy.


    • Improved data security.
    • Increased consistency.
    • Lower updating errors.
    • Reduced costs of data entry, data storage, and data
    retrieval.
    • Improved data access using host and query languages.
    • Higher data integrity from application programs.
    What are the 4 types of databases?

    • Some of the more commonly used categories of database


    include:
    • Hierarchical Databases.
    • Relational Databases.
    • Non-Relational Databases.
    • Object oriented databases.

    You might also like