What is Database and DBMS ?

A database is a collection of data (raw facts and figures) in rows and columns. DBMS is Database Management System and includes database software like MS Access or Oracle Database.

Database is a collection of data arranged in rows and columns. Eg: Class attendance book, which contains ROLLNO, NAME OF STUD, DAY WISEATTENDANCE. Database management system is a software used to add, modify or delete the data. Eg: Oracle

This article is about the computing concept. For instances of the general concept, see Lists of databases. An SQL select statement and its result In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases spans formal techniques and practical considerations, including data modeling, efficient data representation and storage, query languages, security and privacy of sensitive data, and distributed computing issues, including supporting concurrent access and fault tolerance. A database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a database system. Often the term "database" is also used loosely to refer to any of the DBMS, the database system or an application associated with the database. Computer scientists may classify database management systems according to the database models that they support. Relational databases became dominant in the 1980s. These model data as rows and columns in a series of tables, and the vast majority use SQL for writing and querying data. In the 2000s, non-relational databases became popular, collectively referred to as NoSQL, because they use different query languages.

A database is an organized collection of data.

For example:- In a stationary shop, detailed records of the materials

available in the shop is database. Similarly in a computerized

system, we need to maintain several files, we would used database

programs such as Microsoft Access, OpenOffice.org Base, and

MySQL. These database programs are used to organize the data

as per our needs in the computer system.

Database Management System (DBMS) - A database management

system is a software package with computer programs that controls

the creation, maintenance and use of a database. A DBMS allows

different user application programs to concurrently access the same

database. Some of the DBMSs are Oracle, IBM DB2, Microsoft

SQL server, Microsoft Access, PostgreSQL, MySQL, FoxPro , SQLITE