Preview

Dbms

Satisfactory Essays
Open Document
Open Document
318 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Dbms
Data Bases
Data base approach focuses on data integration and data sharing, views data as an organizational resource

Data Base Management System (DBMS) refers to programs that control the data and interfaces between the data and application programs

The data based, DBMS, and the application programs together are termed as data base system

Data base administrator is the person responsible for the data base.

Data base systems separate logical and physical views of data, referred to as program-data independence
Logical view - how the user or programmer conceptually organizes and understands data
Physical view - how and where the data are physically arranged and stored on storage medium

Advantages of program-data independence
Application programmers can code application logic without concern for physical storage the logical view of the task can be changed without changing the physical data storage

Schema - logical structure of the data base
Conceptual level schema - organization wide view of entire data base
External level schema - individual user views of data, subschema
Internal level schema - low-level view of data based, how data are stored
DBMS translates user requests at logical level into physical actions
Accountants are involved with conceptual and external levels, rarely the internal level.

Data Dictionary - information on the structure of the data base
Each data element is described in detail.
Usually maintained automatically by DBMS
Output of data dictionary often includes
Programs where data items are used.
List of synonyms
Data elements used by a user
List of output reports where data element is used.

DBMS languages - functions of creating, changing and querying
Data definition language (DDL) - build data dictionary, initialize, describe logical views, specify security imposed on users.
Data manipulation language (DML) - data maintenance, updating, inserting and deleting, references

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Pt2520 Unit 6 Lab 1

    • 292 Words
    • 2 Pages

    24. What is the difference between the logical design and the physical design of a database?…

    • 292 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Nt1330 Unit 1 Study Guide

    • 1178 Words
    • 5 Pages

    A database management system is implemented to access data in form of queries. File processing system is designed to…

    • 1178 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Pt2520 Unit 6

    • 1447 Words
    • 6 Pages

    Data independence, it exists when we were able to change the database structure or characteristics without affecting the…

    • 1447 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Assingment 1

    • 663 Words
    • 3 Pages

    Applications and utility software are used to access and use data in the DBMS and to manage the computer environment. Application programs developed in programming languages such as C++, Visual Basic that are used to access database in database management system. Utilities are the tools that helps to to manage the computer components such as anti-virus programs.…

    • 663 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    CS-669 Assignment 1

    • 985 Words
    • 4 Pages

    Structural independence when we can change structure of stored data without affecting to access of user’s applications. It is essential, otherwise in case of dependency there would be need to make all necessary adjustments to keep the same type access that the users have.…

    • 985 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Relational Databases

    • 750 Words
    • 3 Pages

    There are many ways to store and access data. One of these ways is using a data base. A database is an integrated collection of logically related data elements that are organized into a common pool of data elements (O 'Brien & Marakas, 2011). These elements are stored in such a way that they are not dependent on any one program or any piece of hardware. Thus allows data to be shared easily between programs.…

    • 750 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Database Design Paper

    • 429 Words
    • 2 Pages

    A database system is a computer term for a structured set of data that can be saved, retrieved, added to or deleted from relatively easy. There are a variety of different databases and the type of database will determine how the data is arranged when it is stored and how that data will be located when it is called upon.…

    • 429 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Relational Databases

    • 4830 Words
    • 20 Pages

    Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in the system and the application programs that use the data. As shown in Figure 4.4, this allows users to separate the way they view the data (called the logical view) from the way the data is actually stored (the physical view). The DBMS interprets the users ' requests and retrieves, manipulates, or stores the data as needed. The two distinct views separate the applications from the physical information, providing increased flexibility in applications, improved data security, and ease of use.…

    • 4830 Words
    • 20 Pages
    Better Essays
  • Satisfactory Essays

    Studies Matters

    • 609 Words
    • 3 Pages

    A ____ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses.…

    • 609 Words
    • 3 Pages
    Satisfactory Essays
  • Best Essays

    A database is a system that is specialized to manage data in a computer application system. Data has many forms, such as text, digital, symbols, graphics, images and sound. The database systems are integral components of current and future command, communication, control and intelligence information systems. (Lunt, 1992, p. 253)…

    • 2529 Words
    • 11 Pages
    Best Essays
  • Powerful Essays

    provides a global quick reference to an organization’s data structures. can be used individually to design an Information System’s (IS) data structure can be used with Data Flow Diagrams to provide a more comprehensive IS logical design.…

    • 1294 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    • DBMS models real world • Data Model is link between user’s view of the world and bits stored in computer • Many models exist • We think in terms of..…

    • 2515 Words
    • 11 Pages
    Good Essays
  • Better Essays

    In this paper the focus will be on next generation systems, objected oriented systems and reversed engineered data models. The concept of a data model is really the design for that specific use. Since not every system uses data models the same then there is just a general bases for the system concepts of the data models.…

    • 1017 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Standardisation of DBMS

    • 298 Words
    • 2 Pages

    A mapping between external and conceptual views gives the correspondence among the records and relation ship of the conceptual and external view. The external view is the abstraction of conceptual view which in turns is the abstraction of internal view. It describes the contents of the database as perceived by the user or application program of that view.…

    • 298 Words
    • 2 Pages
    Satisfactory Essays