What is the difference between covering and overlapping constraints use in DBMS?

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

Was this solution helpful to you?

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

Find solution

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.