Scribd Logo
Upload

Welcome to Scribd!

  • 38 views

    Database Management System (DBMS) An

    Uploaded by

    Khaled Ghanem
    This document provides an introduction to database management systems (DBMS). It explains that a DBMS is software that allows organizations to create, store, organize and retrieve data from one or more databases. A DBMS provides advantages like improved data sharing, consistency and quality. Effective database management involves roles like database administrators who design and implement databases according to organizational policies and security features.

    Copyright:

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

    Database Management System (DBMS) An

    Uploaded by

    Khaled Ghanem
    38 views17 pages
    This document provides an introduction to database management systems (DBMS). It explains that a DBMS is software that allows organizations to create, store, organize and retrieve data from one or more databases. A DBMS provides advantages like improved data sharing, consistency and quality. Effective database management involves roles like database administrators who design and implement databases according to organizational policies and security features.

    Original Description:

    database

    Original Title

    2

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an introduction to database management systems (DBMS). It explains that a DBMS is software that allows organizations to create, store, organize and retrieve data from one or more databases. A DBMS provides advantages like improved data sharing, consistency and quality. Effective database management involves roles like database administrators who design and implement databases according to organizational policies and security features.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    38 views17 pages

    Database Management System (DBMS) An

    Uploaded by

    Khaled Ghanem
    This document provides an introduction to database management systems (DBMS). It explains that a DBMS is software that allows organizations to create, store, organize and retrieve data from one or more databases. A DBMS provides advantages like improved data sharing, consistency and quality. Effective database management involves roles like database administrators who design and implement databases according to organizational policies and security features.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    You are on page 1of 17

    Database Management

    System (DBMS) an
    Introduction
    Intro to DBMS
    Objectives

    Understand why databases are important


    to modern organizations
    Understand how databases work
    Understand how organizations can
    maximize their strategic potential with
    databases
    Intro to DBMS

    Data is a vital part of any organization. It needs to be


    stored, organized, managed, accessed, protected and
    manipulated.
    Operational
    Use databases to:
    Create a book

    Track book sales

    Set salaries and wages

    Pay employees
    Intro to DBMS
    Purpose of DBMS

    The purpose of a database is to keep


    track of things
    Unlike a list or spreadsheet, a database
    may store information that is more
    complicated than a simple list
    Intro to DBMS
    Database Management for Strategic Advantage

    The Database Approach: Foundational Concepts


    DBMS Database Management Systems

    Use a DBMS software to create, store, organize, and


    retrieve data from a single database or several databases
    Example: Microsoft Access
    Intro to DBMS
    Database Management for Strategic Advantage

    Advantages of the Database Approach


    Program-data independence

    Minimal data redundancy

    Improved data consistency

    Improved data sharing

    Increased productivity of application development

    Enforcement of standards

    Improved data quality

    Improved data accessibility

    Reduced program maintenance


    Intro to DBMS
    Database Management for Strategic Advantage

    Effective Management of Databases


    The database administrator (DBA) :

    Works with programmers and analysts to design


    and implement the database
    Works with users and managers to establish
    database policies
    Implements security features and establishes
    database permissions
    Intro to DBMS
    Database Systems

    The four components of a database system are:


    Users

    Database Application

    Database Management System (DBMS)

    Database
    Intro to DBMS
    Database Systems
    Intro to DBMS
    Database Systems - Users

    A user of a database system will


    Use a database application to track things

    Use forms to enter, read, delete and query data

    Produce reports
    Intro to DBMS
    Database Systems Database Application

    A set of one or more computer programs that serves as an


    intermediary between the users and the DBMS
    Application program that read or modify database data by
    sending SQL statements to DBMS.
    Application program to present data to users in the format of
    forms and reports.
    Intro to DBMS
    Database Systems Database Application :
    Functions

    Create and process forms


    Process user queries
    Create and process reports
    Execute application logic
    Control database applications
    Intro to DBMS
    Database Systems DBMS

    A computer program used to create, process and administer


    the database
    DBMS receives request encoded in SQL and translates these
    requests into actions on the database
    DBMS is a large, complicated program that is licensed
    software. Almost majority of the companies never write their
    own DBMS program.
    Intro to DBMS
    Database Systems Database

    The database is a collection of related tables and other


    structures.
    A database is a self-describing collection of related records
    Intro to DBMS
    Functions of DBMS
    Create databases
    Create tables
    Create supporting structures
    Read database data
    Modify database data (insert, update, delete)
    Maintain database structures
    Enforce rules
    Control concurrency
    Provide security
    Perform backup and recovery
    Intro to DBMS
    Organizational DBMS
    Intro to DBMS
    Organizational DBMS

    Organizational database systems typically:


    Support several users simultaneously
    Include more than one application
    Involve multiple computers
    Are complex in design
    Have many tables
    Have many databases

    You might also like