Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Database Management System

    Uploaded by

    praplaysfortnite
    The document discusses database management systems and their benefits. It defines what a database is and its elements. It also describes popular DBMS like MS Access, MySQL, and Oracle. It notes that DBMS arrange data for easy access, reduce redundancy, and ensure security and integrity.

    Copyright:

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

    Database Management System

    Uploaded by

    praplaysfortnite
    4 views7 pages
    The document discusses database management systems and their benefits. It defines what a database is and its elements. It also describes popular DBMS like MS Access, MySQL, and Oracle. It notes that DBMS arrange data for easy access, reduce redundancy, and ensure security and integrity.

    Original Title

    Database management system

    Copyright

    © © All Rights Reserved

    Available Formats

    ODP, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses database management systems and their benefits. It defines what a database is and its elements. It also describes popular DBMS like MS Access, MySQL, and Oracle. It notes that DBMS arrange data for easy access, reduce redundancy, and ensure security and integrity.

    Copyright:

    © All Rights Reserved
    Download as ODP, PDF, TXT or read online from Scribd
    Download as odp, pdf, or txt
    4 views7 pages

    Database Management System

    Uploaded by

    praplaysfortnite
    The document discusses database management systems and their benefits. It defines what a database is and its elements. It also describes popular DBMS like MS Access, MySQL, and Oracle. It notes that DBMS arrange data for easy access, reduce redundancy, and ensure security and integrity.

    Copyright:

    © All Rights Reserved
    Download as ODP, PDF, TXT or read online from Scribd
    Download as odp, pdf, or txt
    of 7

    DATABASE MANAGEMENT SYSTEM

    BY PRATIK GAUTHAM CLS3


    WHAT IS A DATABASE?

     A database is simply an organized collection of data.


     Databases arrange information in such a way that any specific piece of information can be readily accessed.
     A good databases removes duplicates or unnecessary data.
     Size of data, increases the accuracy of data.
    ELEMENTS OF A DATABASE:

     HIERARCHIAL
     NETWORK
     RELATIONAL
     OBJECT-ORIENTATED
    DATABASE MANAGEMENT SYSTEM

    Each field defines information of a certain type for all records. Tables , fields and records form the element of a
    relation.

    Database management involves creating, modifying, deleting and adding data in a database.

    The software that performs these functions is called a Database Management System (DBMS).

    EXAMPLE: MS ACCESS, MYSQL AND ORACLE ARE SOME POPULAR DBMS.


    BENEFITS OF DBMS:

     Reduces data redundancy.


     Controls data inconsistency.
     Facilitates sharing of data.
     Enforces standards.
     Ensures data security.
     Maintains integrity.
    MICROSOFT ACCESS: ONE OF THE POPULAR DBMS APPLICATION

     Microsoft access is one of the most popular DBMS applications.


     It is a relational database where data is stored in the form of tables.
     A relational databases uses multiple tables to organize data and creates relationships between these tables to
    retrieve the data.
     Each specific piece of information on a table is called a value.
     A value is located at the intersection of a column and a row.

    You might also like