DBMS

 DBMS (Database Management System)




DBMS stands for Database Management System. We can break it like this DBMS=Database+ Management System. Database is a collection of data and management system is a set of programs to store abd retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-releted data and set of programs to store and access those data in an easy and effective those data in an easy and effective manner.

The main characteristics of database system:

1.It provide to create, modify and remove the database.

2.To store new information, to change (update) existing information and remove(delete) information.

3.It provides data manipulation using mathematical and logical operator.

4.It provides to generate various report(permanentiy)/adhoc(temporary).

5.It provide data integrity.

What is the need of DBMS?

Database Systems are basically developed for large amount of data.When dealing with huge amount of data, there are two things that require optimization.Storage of data and retrieval of data.

See the source image


Applications of DBMS

Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information.

Mostly data represents recordable facts.Data aids in producing information, which is based on facts. For example, if we have data about marks obtained by all students, we can then conclude about toppers and average marks.




THOUGHT

“Don’t waste your life in, Trying to impress anyone, Just try to improve yourself, it will help your lifetime.”


Comments

Post a Comment

Popular posts from this blog

Introduction of C Language

Image
Hello Friends, Here we will know some basics of C Language. So let's Start...... C Programming C is a powerful general-purpose programming language. It is fast, portable and available in all platforms. If you are new to programming, C is a good choice to start your programming journey. C  is a procedural programming language. It was initially developed by Dennis Ritchie in the year 1972. It was mainly developed as a system programming language to write an operating system. The main features of C language include low-level access to memory, a simple set of keywords, and clean style, these features make C language suitable for system programmings like an operating system or compiler development. Many later languages have borrowed syntax/features directly or indirectly from C language. Like syntax of Java, PHP, JavaScript, and many other languages are mainly based on C language. C++ is nearly a superset of C language (There are few programs that may compil
Read more

Constant in C

Image
                    Constant in C Constant The constant in  C are available to the values which do not change during the execution of the program. There are several types of constant in C: a.Integer Constant 5,10,15......., these are the sequence of the number from 0(zero) to nine without decimal point or fractional part or any other symbols. b.Real Constant Real Constant are often known as floating point constant. Integer constant are unfit to represent floating value,then it is represented by real constant. c. Character Constant Character Constant has two types as follows: 1. Single Character Constant A character Constant is a single character. They are also represented with a single digit or a single special symbol or white space (blank space) enclosed within a pair of single quote(") marks. 2.String Constant String Constant of character in closed within a double quote mark("....").The string may be combination of all kinds of symbol. exa
Read more

Computer generation

Image
                Computer Generation 1st generation The period of 1st generation was 1942-1954. The main features are- *Vaccum tube technology *Unreliable *Supported Machine Language Only *Very Costly *Generate lot of heat *Need A.C *Non Portable *Consumed lot of Electricity 2nd Generation The period of second generation was 1952-1964. The main features are- *Use of transistor *Reliable as compared to first generation computer *Smaller size as compared to first generation *Consumed less electricity *Faster than first generation *Still very Costly *Support machine and assembly language *A.C needed   3rd generation The period of third generation was1964-1972. *The main features are- *Use of integrated circuit *More reliable *Smaller size *Generate less heat *Faster *Still costly *A.C needed *Consumed lesser electricity 4th generation The period of fourth generation was 1972-1990. The main features are- *Very Large Scale Inte
Read more