Database Management System (DBMS)

Definition

A Database Management System (DBMS) is a collection of interrelated data and a set of programs to access those data.

Primary Goals of DBMS

• To store and retrieve data
• Should be convenient and efficient
• Manages large bodies of information
• Provides mechanisms for data manipulation
• Ensures safety of stored information

Data vs Information

Data

Raw, unprocessed facts

Example: 25, Bheem, Dholkpur

Information

Processed data

Example: Bheem is 25 years old and lives in Dholkpur

Database

Collection of interrelated data

Examples: Banking system, Library management, Railways, etc.

Metadata

Data about other data

Examples: Author, Date created, Date modified, File size