Week 3 Project

/

Managing Data Resources—Part 2

DBMS

Con�guring the database technology for complex and rigorous usage solves many traditional �le environment problems. A DBMS is special software for creating and maintaining a database and enabling individual business applications to extract needed data without creating separate �les or data de�nitions in computer programs.

A DBMS includes:

Data De�nition Language: De�nes each data element as it appears in the database.

Data Manipulation Language: Manipulates the data in the database. End users and programmers use this language to extract data from the database according to their requests and applications.

Data Dictionary: Stores and organizes information about the data maintained in a database.

Structured Query Language (SQL) is a popular data manipulation language that gives users and application programs an interactive query language to access the data in databases.

The most important feature of a DBMS is its ability to separate the logical and physical views of data. A programmer works with the logical view of the data and need not be concerned with the data’s physical location. A logical description of the entire database, showing all the data elements and their inter-relationships is called a conceptual schema (media/week3/SU_MIS3101_concept_schema.xls?_&d2lSessionVal=tMO8UB8lK2GctRXeoaaWqV7nV&ou=73907). A data element represents a �eld.

After understanding the concept of DBMS, let us explore the various DBMS models used in digital enterprises.

