Scribd Logo
Upload

Welcome to Scribd!

  • 17 views

    Lecture 2

    Uploaded by

    Ahmad Hussain Shafi SE-3rd
    This document discusses the database approach and advantages of using a database management system (DBMS). The key points are: 1) The database approach was developed to overcome issues with traditional file processing systems where data definitions were embedded in programs rather than stored separately. It emphasizes integration and sharing of data. 2) Advantages of the database approach include program-data independence, planned data redundancy, improved data consistency, accessibility and quality, increased productivity, and reduced maintenance. 3) A DBMS is software that creates, maintains and controls access to databases. It provides an efficient environment for users. Examples include MS Access, SQL Server, and Oracle.

    Copyright:

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

    Lecture 2

    Uploaded by

    Ahmad Hussain Shafi SE-3rd
    17 views13 pages
    This document discusses the database approach and advantages of using a database management system (DBMS). The key points are: 1) The database approach was developed to overcome issues with traditional file processing systems where data definitions were embedded in programs rather than stored separately. It emphasizes integration and sharing of data. 2) Advantages of the database approach include program-data independence, planned data redundancy, improved data consistency, accessibility and quality, increased productivity, and reduced maintenance. 3) A DBMS is software that creates, maintains and controls access to databases. It provides an efficient environment for users. Examples include MS Access, SQL Server, and Oracle.

    Original Title

    lecture 2

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses the database approach and advantages of using a database management system (DBMS). The key points are: 1) The database approach was developed to overcome issues with traditional file processing systems where data definitions were embedded in programs rather than stored separately. It emphasizes integration and sharing of data. 2) Advantages of the database approach include program-data independence, planned data redundancy, improved data consistency, accessibility and quality, increased productivity, and reduced maintenance. 3) A DBMS is software that creates, maintains and controls access to databases. It provides an efficient environment for users. Examples include MS Access, SQL Server, and Oracle.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    17 views13 pages

    Lecture 2

    Uploaded by

    Ahmad Hussain Shafi SE-3rd
    This document discusses the database approach and advantages of using a database management system (DBMS). The key points are: 1) The database approach was developed to overcome issues with traditional file processing systems where data definitions were embedded in programs rather than stored separately. It emphasizes integration and sharing of data. 2) Advantages of the database approach include program-data independence, planned data redundancy, improved data consistency, accessibility and quality, increased productivity, and reduced maintenance. 3) A DBMS is software that creates, maintains and controls access to databases. It provides an efficient environment for users. Examples include MS Access, SQL Server, and Oracle.

    Copyright:

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

    CSC241 Database Systems

    Lecture # 2
    By
    Maria Gul

    1
    Database Approach
    • Why database approach?

    • Two main factor


    ➢ In TFPS the definition of data is embedded
    in the application programs rather than
    being stored separately and
    independently.
    ➢ There is no control over the access and
    manipulation of data in TFPS.

    • To overcome above problems database


    approach was developed
    2
    Database Approach
    • Database approach emphasizes the
    integration and sharing of data throughout
    the organization.

    • Single centralized database is used for all


    department of organization.

    • Self describing collection of integrated


    records.

    • Remove nearly all the drawback of file


    processing system.
    3
    Database Approach
    Advantages of Database Approach
    • Program-data independence
    • Planned data redundancy
    • Improved data consistency
    • Improved data sharing
    • Increased productivity of application
    development
    • Improved data quality
    • Improved data accessibility and
    responsiveness
    • Reduced program maintenance
    • Improved decision support

    4
    Database Approach
    Advantages of Database Approach
    Library Examination Registration

    Library Examination Registration


    Applications Application Application

    Database Management System

    University Student
    Database
    5
    Database Approach
    Advantages of Database Approach
     Program-data independence
    ➢ The separation of data description from
    the application program is called data
    independence.

    ➢ Data descriptions are store in a central


    location called repository.
    6
    Database Approach
    Advantages of Database Approach
     Planned Data Redundancy
    ➢ Single centralized database is used for all
    department of organization. So, there is no
    need to store the data in several places.
     Improved Data Consistency
    ➢ Eliminating or controlling data redundancy
    improve data consistency.
    7
    Database Approach
    Advantages of Database Approach
     Improved Data Sharing
    • Data is stored in central location, so it is
    accessible to all users of the organization.
    • Authorized users are granted permission
    to use the database.
    • User view is provided to one or more user
    to use data.

     Increased Productivity of Application


    Development
    • Reduces the time and cost for developing
    new business applications.

    8
    Database Approach
    Advantages of Database Approach
     Improved Data Quality
    • Database designer specify the constraints
    to improve the quality of data.
    • Database approach provide number of
    tools and process to improve the quality of
    data.

     Improved Data Accessibility and


    Responsiveness
    • Accessing and retrieving of data is very
    easy because DBMS uses SQL through
    which data can be accessed fastly.

    9
    Database Approach
    Advantages of Database Approach
     Reduced Program Maintenance

    • Program maintenance includes: add new


    data item and types, change the formats of
    data etc.
    • In database approach changes either in
    application program or data done without
    affecting other factors.

     Improved Decision Support


    • Data warehouse is used for decision
    making process.

    10
    Cost and Risk of the Database
    Approach
    • New, specialized personnel
    • Installation and management cost and
    complexity
    • Conversion costs
    • Need for explicit backup and recovery
    • Organizational conflict

    11
    Database Management System
    • A database management is a software that is
    used to create, maintain, and provide
    controlled access to user databases.

    • DBMS provides an environment that is both


    convenient and efficient to use.

    • Example of DBMS: MS Access, SQL Server,


    Oracle……

    12
    Database Management System
    • A database management is a software that is
    used to create, maintain, and provide
    controlled access to user databases.

    • DBMS provides an environment that is both


    convenient and efficient to use.

    • Example of DBMS: MS Access, SQL Server,


    Oracle……

    13

    You might also like