Follow us on Social Media:

MySQL Database Administrator

Boost Your Quick Knowledge in MySQL DBA Work, Concepts, Tips and Trick

Friday, 9 March 2018

What is the difference between Database and DBMS?

Database is a collection of related data stored in several tables and linked through different-different keys. We can create and have several databases in a Database-product instance .

DataBase Management System (DBMS) is a piece of software that manages databases and lets you create, edit and delete databases, their tables and their data.
DBMS is a concept and a set of rules that all or major Database Systems follows. Some Database systems follows most of these rules, and some follows only only certain rules.
Most Database products/tools uses SQL language, which is just a ANSI standard, and is used as a base with most Database systems, like Microsoft SQL Server, Oracle, MySQL, IBM DB2, PostgreSQL and SQLite have used this as a base and extended/enhanced in their database systems.

No comments:

Please Like and Subscribe us ....

Please visit the website on daily basis , Your New articles will publish at any moment. Please Subscribe us for getting Latest Updates...