DBMS Notes

Database System

The Database System store data in electronic storage called database and performs various operations on this data through DBMS software.

Descriptive diagram of database system

Basic Elements of Database System 

There are three basic terms of Database system. Students mostly confuse with these terms. These three terms are totally different to each others. lets understand,

1.    Databases

A database is a well-organized collection of related data which is store in electronic storage. This data may be in any format either structured or unstructured.

Term Data: In simple words, data is some collection of related facts to any object. For example, your name, RollNo, age, height, weight, etc. are some data related to you.

A cylindrical structure represents the database storage. As we can see the following diagram.

Database diagram in Database system

 

2.    Database Management System (DBMS)

It concern with various operations (i.e. add, update, delete etc.) on database data. DBMS use any of the following software to perform various operations on data As,

  • SQL Serve
  • MYSQL
  • DB2
  • Oracle 9i, 11, 12c etc.

3.    User/Applications/Other DB’s

Users, applications or other DB’s need to intact with data which is actually present in storage of database. This interaction with data is possible with the help of any DBMS software (i.e. MYSQL).

Note: when a user fills an online form at any website and submits it, then through DBMS software of that website, data is updated in Database.

In upcoming lectures, we will learn about Structure and Unstructured Data

Help Other’s By Sharing…

Contact Us

Burewala, Vehari, Punjab, Pakistan

cstaleem1@gmail.com

Website: CStaleem.com

Pin It on Pinterest