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

First in C programming

                First C Program  To write the first c program, open the C console and write the following code: #include <stdio.h>      int  main(){     printf( "Hello C Language" );     return  0;    }   #include <stdio.h> includes the standard input output library functions. The printf() function is defined in stdio.h . int main() The main() function is the entry point of every program in c language. To compile and run the c program, by menu and by shortcut. By shortcut key Press ctrl+f9 keys compile and run the program directly. User will see the output on the screen by pressing the alt+f5keys. Now, press Esc to return the turbo c++ console.  printf and scanf is in lowercase because it is a keywords. Keywords is a set of reserved words. All keywords...
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...
Read more