What is the difference between Database and DBMS?
-
What are some examples of database and DBMS?
-
Answer:
Very well answered by Thomas Tydal.
Josep Lluis Larriba Pey at Quora Visit the source
Other answers
A database is any collection of data, it can be words you write on a piece of paper or a digital file. A 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. Examples of a DBMS are MySQL, MS SQL Server, Oracle, PostgreSQL and SQLite.
Thomas Tydal
Generally if anyone asked about the difference between Database and DBMS then everyone says that both are same but there is huge difference between them are as:- 1.Both are part of the Database system. 2.DBMS contains a) Query Processing software. b)storage Management software. Examples :-MySQL, MS SQL Server, Oracle 3.Databse contains a) Data b)schema(structure of the table ). 4.Both are interdependent. For further Refernces please referDatabase System Concepts Sixth Edition http://www.cs.yale.edu/homes/avi http://www.lehigh.edu/%7Ehfk2/hfk2.html http://www.cse.iitb.ac.in/%7Esudarsha link:- http://www.db-book.com/
Pankaj Singh
DBMS which means Database Management System, which 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 have used this as a base and extended/enhanced in their database systems.Database is a collection of related data stored in several tables, and linked through foreign keys. You can create and have several databases in a Database-product instance. Check about Database in this video:I've written a blog on the same, check here: http://sqlwithmanoj.com/2015/05/03/what-is-sql-plsql-t-sql-and-difference-between-them/
Manoj Pandey
DBMS- is a software that manages databases created by you. It provides facility to edit and delete it. It is like a database manager.This is a whole system that provides different functionalities of search, creation/maintenance etc. Eg. Oracle,db2,Microsoft Access.a Database- Collection of interelated data. It is a system intended for storing and retreiving large amount of data. It is made up of tables and contains rows and columns. It is like spreadsheets,excel.
Aditya Sharma
Thomas Tyndall's answer is correct on the fine point, though many in the field will run the terms together interchangeably. Not unlike predilections in the war of pronunciation between "Sequel" and Ess-Cue-Ell, some folks would just rather say words than emit lettered acronyms from their mouths.
David Brower
Simply put, A database is the set of all data relevant to a particular domain/area/enterprise. A DBMS is a specialized system application that helps you manage databases. Wikipedia: https://en.wikipedia.org/wiki/Database
Alam Mushir
DBMS is the system under which many databases http://created.ItIt basically organizes all databases. Database is the repository under which variaous table are created.
Anil Joshi
Related Q & A:
- What Is The Difference Between Magicjack And Magicjack Plus?Best solution by Yahoo! Answers
- what is the difference between sum of first n primes and prime(prime(n?Best solution by Mathematics
- What's the difference between Fullmetal Alchemist and Fullmetal Alchemist: Brotherhood?Best solution by Yahoo! Answers
- What's the difference between Current (I) and Potential Difference (V?Best solution by diffen.com
- What does it mean to be unresponsive? What's the difference between unresponsive and unconscious?Best solution by answers.yahoo.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.