Database Management System and SQL
Database Management System and SQL
  • Database Management System and SQL
  • Database
    • Introduction to Database
      • Definition
      • File System
      • Different types of Database
      • Uses of DBMS
      • Basic Terms in Database
      • Query Language
    • View of Data
      • Data Abstraction
      • Schema & Instance
      • Data Models
    • Database Architecture
      • DBMS Tier Architecture
      • Three Schema Architecture
      • Data Independence
    • Relational Database Management System (RDBMS)
      • Entity-Relationship (ER) Model
      • Attributes
      • Keys
      • Relationship
    • Functional Dependencies
    • Normalization
  • MySQL
    • Terminology
    • Database Statements
    • Table
      • Data Type
      • Create
      • Show
      • Describe
      • Drop
      • Alter
      • Auto Increment
      • Index
    • Insert
    • Select
      • Condition
      • Aggregate Functions
      • Join
    • View
    • Delete
    • Update
    • MySQL Constraints
      • NOT NULL
      • DEFAULT
      • CHECK
      • UNIQUE
      • PRIMARY KEY
      • FOREIGN KEY
Powered by GitBook
On this page
  • Data
  • Information
  • Database
  • Database Management System (DBMS)
  • Database System

Was this helpful?

  1. Database
  2. Introduction to Database

Definition

Data, Information, Database, Database Management System, Database System

Data

Data is the unit of Information. It is a fact related to any object in consideration, such as a student’s name, ID, phone, email address, etc. Text, numbers, images, files, PDFs, audio, and videos can all be considered data.

Data is a representation of facts, concepts, or instructions in a formalized manner suitable for communication, interpretation, or processing by humans or by automatic means.

Any representation such as characters or analog quantities to which meaning is or might be assigned. Generally, we perform operations on data or data items to supply some information about an entity.

Information

Information is a set of data that is processed in a meaningful way according to the given requirement. Information is processed, structured, or presented in a given context to make it meaningful and useful.

It is processed data which includes data that possess context, relevance, and purpose. It also involves the manipulation of raw data.

Information assigns meaning and improves the reliability of the data. It helps to ensure undesirability and reduces uncertainty. So, when the data is transformed into information, it never has any useless details.

Database

The database is a collection of records or a collection of logically related data.

A database is a systematic, organized collection of data so that it can be accessed and managed efficiently. The main purpose of the database is to operate a large amount of information by storing, retrieving, and managing data.

Database Management System (DBMS)

A program (or set of programs) that manages details related to storage and access to database(s).

A database management system (DBMS) is system software for creating and managing databases in a reliable and efficient way. A DBMS makes it possible for end users to create, read, update and delete data in a database.

Database Management Systems (DBMS) is a collection of programs which enables its users to access database, manipulate data, and help in representation of data. It also helps control access to the database by various users.

Charles Bachmen’s Integrated Data Store (IDS) is said to be the first DBMS in history.

Database System

Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system.

PreviousIntroduction to DatabaseNextFile System

Last updated 5 months ago

Was this helpful?