Friday, 5 May 2017

Database and Database Management System (DBMS)

Database 
A database is any collection of data, it can be words you write on a piece of paper or a digital file. 
It is a collection of interrelated data. 
It is a system intended for storing and retrieving large amount of data. 
DB is made up of tables and contains rows and columns. It is like spreadsheets, excel.


Database Management System (DBMS)
Database Management System (DBMS) is a collection of programs which enables its users to access database, manipulate data, reporting / representation of  data.
Basically it is a piece of software that manages databases and lets you create, edit and delete databases, their tables and their data. 
Examples of a DBMS are MySQL, MS SQL Server, Oracle, PostgreSQL and SQLite.

No comments:

Post a Comment